almost 6 years ago
<-- Chapter 23: SQL Wildcards
SQL Aliases are used to rename a particular table name or column name in a temporary manner. In a SQL statement , any table or column name can be temporary change.
SQL Syntax for Columns :-
SELECT columnname AS columnaliasname
SQL Syntax for Tables :-
FROM tablename AS tablealiasname;
Lets see an examples from the below table "employees" :-
Alias TABLE COLUMN SQL syntax :-
SELECT `name` AS [Employee Name], `designation` AS [Employee Designation]
Now run the above SQL query, we will see the output below :-
Now we can see here, columns "name" and "designation" are renamed temporary to Employee Name and Employee Designation.
Alias TABLE SQL syntax :-
FROM `employees` AS `emp`
Now we can see here, table name "employee" is renamed temporary to "emp" .
Chapter 25: SQL Joins -->
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?
Terms of Service
| © copyright 2021 FindNerd.com. All rights reserved.
Sign up using