Eliminating Duplicate Records

Top  Previous  Next

 

When you perform queries on your data, you may find that the results contain duplicate records.

 

Example

If you were to select the country from the customer table (customer personal information), it would return each record that has a country, hence the country would repeat for each customer in that country.  If you which to eliminate this repetition use the Select Distinct SQL feature.

 

To Eliminate Duplicate Records:

 

1. Right Click on the grey background of query work area, and then select Distinct from the popup menu.

 

edt_Viz_SQL_distinct_010

 

2. You will see the Check sign by the Distinct menu. This means the duplicate rows will be eliminated from your result set.

 

3. Validate the result set by viewing the data in the SQL Builder

The above example should give you a list of all the countries, in which each country is listed only once.