COMPUTER SCIENCE AND ENGINEERING
SQL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which SQL statement can eliminate duplicate rows?
|
SELECT UNIQUE
|
|
SELECT DIFFERENT
|
|
SELECT INDEX
|
|
SELECT DISTINCT
|
Explanation:
Detailed explanation-1: -The DISTINCT keyword in the SELECT clause is used to eliminate duplicate rows and display a unique list of values. In other words, the DISTINCT keyword retrieves unique values from a table.
Detailed explanation-2: -Answer: The DISTINCT keyword is used to remove the duplicate rows in a table.
Detailed explanation-3: -The DISTINCT keyword eliminates duplicate rows from a result.
There is 1 question to complete.