Latest Tutorials| Questions and Answers|Ask Questions?|Site Map

Home Quartz SQL Alias

Related Tutorials


Share on Google+Share on Google+

SQL Alias

sql alias

SQL Alias


SQL Alias is the another name given to the existing table and the column. The SQL Alias make the table and column name easy to read and write.

Understand with Example

The Tutorial illustrate a example from 'SQL Alias'. To grasp this example, we create a table 'Stu_Table'. The create table is used to create a table 'Stu_Table' and 'Lib_Table' that include field attribute and data type respectively.

Create Table Stu_Table

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

Create Table Lib_Table

create table Lib_Table(Stu_Id integer(2), Lib_no integer(5))

Insert data into Stu_Table

The insert into add the records or rows to the table 'Stu_Table' and 'Lib_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(4,'Bhanu',10);
insert into Stu_Table values(5,'Santosh',10);

 Insert data into Lib_Table

insert into Lib_Table values(1,101)
insert into Lib_Table values(2,102)
insert into Lib_Table values(3,103)
insert into Lib_Table values(4,104)
insert into Lib_Table values(5,105)


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


Stu_Id Lib_no
1 101
2 102
3 103
4 104
5 105

SQL Alias Query

The given below SQL Query takes alias name for table 'Stu_Table' as s and 'Lib_Table' as l.

select s.stu_id, s.stu_name, s.stu_class, l.lib_no 
from Stu_Table as s , Lib_Table as l
where s.stu_id = l.stu_id


Stu_Id Stu_Name Stu_Class Lib_no
1 Komal 10 101
2 Ajay 10 102
3 Rakesh 11 103
4 Bhanu 11 104
5 Santosh 12 105

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 Alias  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image