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 |

|