MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which SQL statement can eliminate duplicate rows?
A
SELECT UNIQUE
B
SELECT DIFFERENT
C
SELECT INDEX
D
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.