SQLite Distinct keyword

SQLite's DISTINCT keyword is used with the SELECT statement to eliminate all duplicate records and obtain only a unique record.

There may be a situation where there are multiple duplicate records in a table. The DISTINCT keyword is particularly meaningful when fetching such records, as it only fetches a unique record rather than duplicate records.

Syntax

The basic syntax of the DISTINCT keyword used to eliminate duplicate records is as follows:

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

Example

Assume that the COMPANY table has the following records:

ID ID name ------------------------------------------------------------------------------------------------—
1 Paul 32 California 20000.0
2 Allen 25 Texas 15000.0
3 Teddy 23 Norway 20000.0
4 Mark 25 Rich-Mond 65000.0
5 David 27 TEXAS 85000.0
6 Kim 22 South-Hall 45000.0
7 James 10000.0
8 P AUL 24 Houston 20000.0
9 James 44 Norway 5000.0
10 James 45 Texas 5000.0

First, let's look at the following SELECT query, which returns duplicate salary records:

sqlite> SELECT name FROM COMPANY;

This will produce the following results:

NAME
----------
Paul
Allen
Teddy
Mark
David
Kim
James
Paul
James
James

Now, let’s use the DISTINCT key in the above SELECT query Word:

sqlite> SELECT DISTINCT name FROM COMPANY;

This will produce the following results without any duplicate entries:

NAME
----------
Paul
Allen
Teddy
Mark
David
Kim
James

← SQLiteHaving clause

SQLite Distinct keyword

Syntax

Example

php.cn