Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 45 of 90

Querying Using SQL — Question 5

Back to all questions
5
Question

Question 5

DISTINCT and its counterpart, ALL, can be used together on single field in a SELECT statement.

Answer

False

Reason — In SQL, DISTINCT and ALL cannot be used together on a single field in a SELECT statement. As DISTINCT eliminates duplicate rows from the results, while ALL includes all rows, including duplicates. Therefore, attempting to use them together on the same field would result in a syntax error.