FlipKart Offer

Translate to Tamil

Amazon Best Offer

AliExpress Offers

Online Income

Friday, 10 December 2010

SQL Alias









You can give a table or a column another name by using an alias

Syntax 
SELECT column_name AS alias_name
FROM table_name AS alias_name


The "custmast" table

custcode
custname
city
qty
rate
1
Siva
Srivilliputtur
50
70
2
Bala
Sivakasi
30
56
3
Kanna
Madurai
100
200
4
Vijay
Chennai
30
30
5
Kodee
Sandnes
60
80
5
Kodee
Srivilliputtur
60
30

Example 
Select cm.custcode as Ccode,cm.custname as Cname from custmast as cm where cm.custcode=1


Output

Ccode
Cname
1
Siva

 Share This Post


Smilely

Services

© 2014