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.

Please follow and like us: