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?
- SELECT DISTINCT column N FROM table_name WHERE [condition]
- SELECT column N FROM table_name WHERE [condition]=DISTINCT
- 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.