ALIAS is used to give temporary name to tables,columns.
The purpose of ALIAS is used to rename table or column for particular SQL Query.It will not affect on any table or database permanently.
When You are writing query to get records from multiple tables, You can alias tables or columns.
Syntax : Alias for Table
SELECT Column1, Column2 FROM Table_Name AS Alias_Name Where condition
Syntax : Alias for Column
SELECT Column1, Column2 AS Alias_Name FROM Table_Name Where condition
EXAMPLE: There are two Table “Employee” and “Department”
The following query will show Table Alias and Column Alias
SELECT E.NAME,E.Salary AS EmpSalary, D.Department AS DepartmentName FROM Employee E , DEPARTMENT D
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.