Sunday, 20 November 2011


SQL allow to table or a column another name by using an Alias. This is a good habit to do you can avoid very long or complex table names or column names.

Alias Example

Syntax:
SELECT Column_Name AS Alias_Name,... FROM Table_Name
Example Statement:
SQL> SELECT S_Name AS Name, 
Total AS Mark_Total,
Percentage AS Per FROM Student_Details;
Example Result:

NameMark_TotalPer
Jay50777.84
Ajay48774.92
Bhavesh46972.15
Jaimin46371.23
Dolar42565.38
SQL GUIDE

0 comments:

Post a Comment

TrainingHUB. Powered by Blogger.

Total Pageviews

THE BEST QTP TRAINING INSTITUTE IN HYDERABAD

QTP Training in hyderabad

Sql Tutorial

Popular Posts

Our Facebook Page

TrainingHUB

Followers