Which SQL keyword must be used to remove duplicate rows from the result?

Options
- DELETE
- DISTINCT
- NOT EXIST
- UNIQUE


CORRECT ANSWER : DISTINCT

Discussion Board
Explanation.

Answer : DISTINCT.

The SQL DISTINCT keyword is used after the SELECT statement and is used to eliminate all the duplicate records and fetch the unique records.


Jayesh Sonar 03-1-2015 11:07 PM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement