SQL Distinct

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

SELECT DISTINCT price FROM coder_books;

Result

SELECT DISTINCT price, title FROM coder_books;

Result