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]      

Related questions

0 votes
asked Nov 13, 2021 in SQLite by sharadyadav1986
0 votes
asked Nov 12, 2021 in SQLite by Robin
...