Home » MCQs » SQLite MCQs

What is the syntax of SQLite DISTINCT Clause?

91. What is the syntax of SQLite DISTINCT Clause?

1. SELECT DISTINCT column1, column2....columnN
   OF table_name;
2. SELECT DISTINCT column1, column2....columnN
   FROM table_name;
3. SELECT column1, column2....columnN
   FROM table_name;
4. SELECT column1, column2....columnN
   OF table_name;

Answer: B)

SELECT DISTINCT column1, column2....columnN  
FROM   table_name;

Explanation:

The syntax of SQLite DISTINCT Clause is -

SELECT DISTINCT column1, column2....columnN  
FROM   table_name;