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.)


Related Content

Advertisement
 
▲