Computer Science
DISTINCT and its counterpart, ALL, can be used more than once in a SELECT statement.
SQL Queries
2 Likes
Answer
False
Reason — In SQL, both DISTINCT and ALL keywords can be specified only once in a given SELECT clause.
Answered By
3 Likes
Related Questions
SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.
The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.
DISTINCT and its counterpart, ALL, can be used together on single field in a SELECT statement.
ORDER BY can be combined with the SELECT statements.