top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration

Facebook Login
Site Registration

What are the two ways to specify a column alias?

+1 vote
46 views
What are the two ways to specify a column alias?
posted Nov 19, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

1.Naming the alias after the column specification separated by a space .
Ex: Select empid id, fname first from employee
2. Use of an 'AS' word to specify the alais more clearly
Ex: Select empid as id, fname as first from employee

answer Nov 24, 2014 by Arun Gowda
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...