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



Home Sql SQL Alias

Related Tutorials


 
 

Share on Google+Share on Google+

SQL Alias

Advertisement
Alias name is given to table and column. In SQL we can give a table or column another name by using an Alias.

SQL Alias

     

 

Alias name is given to table and column. In SQL we can give a table or column another name by using an Alias. The Alias help you to make your complicated table and column name simpler and sorter.

Understand with Example

The Tutorial illustrate an example to understand SQL Alias. In this example, before understanding Alias, we create a tables 'Stu_Table'and 'Lib_Table' using create table statement.

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 value into your respective tables

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_Table

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

Lib_Table

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

SQL Alias Query

The given below example show you the SQL Alias Query. In this case, the alias name for Stu_Table is 's' and Lib_Table is 'l'.As you can see the Alias Name Query make the table name simple and easier to write and read.

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

Result

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
Advertisements

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: December 20, 2008

Related Tutorials

Discuss: SQL Alias  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
vikash
November 26, 2012
response

i love rose india because all query are explain briefly.
DMCA.com