Multiple choice technology databases

Distinct keyword must appear directly after the select keyword in SQL Query....

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In SQL, the DISTINCT keyword must appear immediately after the SELECT keyword and before the column list. This syntax is mandatory - DISTINCT cannot appear elsewhere in the SELECT clause. The keyword is part of the SELECT clause syntax, not a separate clause.

AI explanation

True is correct. In standard SQL syntax, DISTINCT is a modifier of the SELECT clause and must immediately follow the SELECT keyword — e.g., SELECT DISTINCT col1, col2 FROM table. You cannot place DISTINCT partway through the column list (like SELECT col1, DISTINCT col2) or after FROM; it applies to the entire row being selected, not to an individual column, which is why its position right after SELECT is mandatory.

Keep practicing — related questions