SQLite DISTINCT watchword is utilized related to SELECT articulation to dispense with all the copy records and bringing just the remarkable records.
There might be a circumstance when you have different copy records in a table. While getting such records, it bodes well to get just extraordinary records as opposed to bringing copy records.
Syntax
Following is the fundamental sentence structure of DISTINCT watchword to take out copy records.
SELECT DISTINCT column1, column2,.....columnN
FROM table_name
WHERE [condition]
Example
Consider COMPANY table with the accompanying records.
ID NAME AGE ADDRESS SALARY
---------- ---------- ---------- ---------- ----------
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 24 Houston 10000.0
8 Paul 24 Houston 20000.0
9 James 44 Norway 5000.0
10 James 45 Texas 5000.0
To start with, let us perceive how the accompanying SELECT question returns copy compensation records.
sqlite> SELECT name FROM COMPANY;
This will deliver the accompanying outcome.
NAME
----------
Paul
Allen
Teddy
Mark
David
Kim
James
Paul
James
James
Presently, let us utilize DISTINCT watchword with the above SELECT question and see the outcome.
sqlite> SELECT DISTINCT name FROM COMPANY;
This will deliver the accompanying outcome, where there is no copy passage.
NAME
----------
Paul
Allen
Teddy
Mark
David
Kim
James