Javatpoint Logo
Javatpoint Logo

SQLite DISTINCT Clause

The SQLite DISTINCT clause is used with SELECT statement to eliminate all the duplicate records and fetching only unique records.

It is used when you have multiple duplicate records in the table.

Syntax:

Example:

We have a table named "STUDENT", having the following data:

Sqlite Distinct clause 1

First Select NAME from "STUDENT" without using DISTINCT keyword. It will show the duplicate records:

Output:

Sqlite Distinct clause 3

Now, select NAME from "STUDENT" using DISTINCT keyword.

Output:

Sqlite Distinct clause 3
Next Topic#




Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


B.Tech / MCA