Distinct

SQL DISTINCT

The DISTINCT is used into a select query to eliminate duplicate records and returns the unique values.

Syntax

SELECT DISTINCT name_of_column FROM name_of_table;

Example

Table of books

SELECT DISTINCT price FROM books;

Output