SQLite DISTINCT Clause

The SQLite DISTINCT clause is used with SELECT statement to eliminate all the duplicate records and fetching only unique records.

It is used when you have multiple duplicate records in the table.

Syntax:

snippet

SELECT DISTINCT column1, column2,.....columnN 
FROM table_name
WHERE [condition]

Example:

We have a table named "STUDENT", having the following data:

First Select NAME from "STUDENT" without using DISTINCT keyword. It will show the duplicate records:

snippet

SELECT NAME FROM STUDENT ;

Output:

Now, select NAME from "STUDENT" using DISTINCT keyword.

snippet

SELECT DISTINCT NAME FROM STUDENT;

Output:

Related Tutorial

1 SQLite WHERE Clause

2 SQLite AND Operator

3 SQLite OR Operator

4 SQLite LIKE Clause (Operator)

5 SQLite GLOB Clause (Operator)

6 SQLite LIMIT Clause

7 SQLite ORDER BY Clause

8 SQLite GROUP BY Clause

9 SQLite HAVING Clause

10 SQLite DISTINCT Clause

11 SQLite Union Operator

12 SQLite Union All Operator

Try it

Contents +