DISTINCT Clause in SQLite

SQLite DISTINCT Clause
To fetch only the unique records from a table the SQLite DISTINCT clause is used with the SELECT statement.

Syntax:

SELECT DISTINCT column_1, column_2,.....column_N   
FROM table_name  
WHERE conditions;

Example:
TEACHERS Table:

SELECT DISTINCT SUBJECT 

FROM TEACHERS;

Output:

SUBJECT
Geology
Physics
Chemistry

Explanation:
In the above example, all the duplicate records from the table are eliminated and only the unique records are fetched from the SUBJECT column of the TEACHERS table.