Home Quartz SQL SELECT DISTINCT Statement

Related Tutorials


 
 

Share on Google+Share on Google+

SQL SELECT DISTINCT Statement

Advertisement
This page discusses - 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
Advertisement

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 18, 2011

Related Tutorials

Discuss: SQL SELECT DISTINCT Statement  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com