0 votes
in SQLite by
What is the use of DISTINCT clause in SQLite?

1 Answer

0 votes
by

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]      

...