Home » MCQs » Transact-SQL (T-SQL) MCQs

Which of the following is the correct syntax to use the DISTINCT keyword?

21. Which of the following is the correct syntax to use the DISTINCT keyword?

1. SELECT DISTINCT column N FROM table_name WHERE [condition]
2. SELECT column N FROM table_name WHERE [condition]=DISTINCT
3. SELECT column N DISTINCT FROM table_name WHERE [condition]

Answer: A) SELECT DISTINCT column N FROM table_name WHERE [condition]

Explanation:

SELECT DISTINCT column N FROM table_name WHERE [condition], is the correct syntax to use DISTINCT keyword in T-SQL.