Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 74 of 78

Simple Queries in SQL — Question 8

Back to all questions
8
Question

Question 8

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.