Home Sql SQL Alias

SQL Alias
Posted on: December 20, 2008 at 12:00 AM

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.

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_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 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

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

Related Tags for SQL Alias:
sql, c, table, make, column, read, name, alias, write, tab, to, e, it, not, li, in, no, as, m, sti, ad, me, umn, s, col, k, is, iv, ea, existing, and, xi, s, s, ri, th, st, ab, abl, exi, lum, nd, ol, o

«Previous Index Next»