What is the use of DISTINCT clause in SQLite?

SQLite - Interview Questions

The DISTINCT clause is always used with SELECT statement. It is used to retrieve only unique records and restrict the duplicate entries.

It is used when the table has multiple duplicate records.

Syntax :

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

More Technologies Interview Questions