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 wish to eliminate this repetition use the Select Distinct SQL feature.

 

To Eliminate Duplicate Records:

 

1. Click the Query Tab in the lower pane to display the SQL text of your query.

 

sql_editor

 

2. Type the word 'Distinct' after the word 'Select'.

 

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