SQL SELECT DISTINCT Statement

In this tutorial, we will learn how to use the DISTINCT Statement in SQL Query with an example.

The SQL DISTINCT statement returns unique data from the database table.

syntax of the Distinct statement

SELECT DISTINCT column1, column2, ... FROM table_name;

Database Example

Consider the student table having the following records:

First, we run the SELECT query on the City column in the above table, which returns the duplicate City records.

SELECT `City` FROM student;

Output:-

Now, we run the above Query with DISTINCT Keyword, It will return only unique city records.

SELECT DISTINCT `City` FROM student;

Output:-