over 4 years ago
It is used to give temporary names to table and columns. It is very useful for situations where column or table names are too long.
SELECT columnname AS alias_name FROM tablename;
This syntax is used for giving temporary name to column.
SELECT columnname(s) FROM tablename AS alias_name;
This syntax is used for giving temporary name to table.
SELECT EmployeeName AS Name FROM Employee;
In this query shorthand(alias) name for EmployeeName is Name.
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using