SQL Distinct
The SQL DISTINCT is used to eliminate duplicate records and returns unique values.
Distinct syntax
-- select distinct column records from table
SELECT DISTINCT column_name FROM table_name
-- select specific columns
SELECT DISTINCT column_name1, column_name2 FROM table_name
Distinct example
Coder books table
ID | Title | Price | Description |
---|
1 | Learn SQL | 20 | Learn SQL language |
2 | Learn MySQL | 22 | Learn MySQL language |
3 | HTML book | 17 | Learn HTML |
4 | Learn PHP | 20 | Introduction to PHP |
5 | Learn PHP | 20 | PHP course |
SELECT DISTINCT price FROM coder_books;
Result
SELECT DISTINCT price, title FROM coder_books;
Result
Price | Title |
---|
17 | HTML book |
20 | Learn PHP |
20 | Learn SQL |
22 | Learn MySQL |