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 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
