SQL SELECT DISTINCT Statement

This page discusses - SQL SELECT DISTINCT Statement

SQL SELECT DISTINCT Statement

SQL SELECT DISTINCT Statement

     

In this example we will show you the usage of Distinct clause with the select statement. The SQL Distinct clause is used with the Select statement to show all unique records from database.  In this example, the columns of table contains duplicate values. i.e. repeated value in the column. In order to overcome the duplicate values from a column, we will use SELECT DISTINCT statement to eliminate duplicate values from the column.

Understand with Example

The Tutorial illustrates you an example from SQL Select Distinct Statement. The create table statement help you to create a table 'Stu_Table'.

SQL statement to create table:

 

 

create table Stu_Table(Stu_Id integer(2), Stu_Name varchar(15), Stu_Class varchar(10));

Insert data into Stu_Table

The Insert into statement add the records or rows into table 'Stu_Table'.

SQL statement to insert data into table:

insert into Stu_Table values(1,'Komal',10);
insert into Stu_Table values(2,'Ajay',10);
insert into Stu_Table values(3,'Rakesh',10);
insert into Stu_Table values(3,'Bhanu',10);
insert into Stu_Table values(4,'Santosh',10);

Stu_Table

The Select statement return you the records from a table 'Stu_Table'.

Records in the table:

Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10

SQL SELECT DISTINCT Syntax

The SQL Distinct clause can be used with the Select statement to get all unique records from database

SELECT DISTINCT columnName(s)
FROM tableName

SQL SELECT DISTINCT Query

You can run the following query to retrieve unique records from the table:

SELECT DISTINCT Stu_Id, Stu_Name, Stu_Class
FROM Stu_Table;

Result of the above query:

Stu_Id Stu_Name Stu_Class
1 Komal 10
2 Ajay 10
3 Rakesh 10
4 Bhanu 10
5 Santosh 10