Sql Query To Use a ' SELECT ' statement with Alias or 'AS"

To create a short name for a long column or table name temporarily. Then we can use an ' AS ' statement or Alias.

This is mainly used in joins,i.e when using two tables. Suppose the two tables have the same column name ( for e.g id), then it can easy to identify if Alias is used with the column name.

Database

Theme

Enter - Select * from table_name;

Output

Similar Program

#	Program	Language
1	Sql Query To Use a ' SELECT ' statement with LIKE Clause	SQL
2	Sql Case Sensitive Query Without Semicolon	SQL
3	Sql Query To Retrieve Employees Data	SQL
4	Sql Query To Add Column Using ADD With ALTER Command	SQL
5	Sql Query To Drop Table	SQL
6	Sql Query to retrieve data using Order By in Ascending and Descending Order in priority	SQL
7	Sql Query To Use a ' SELECT ' statement with IN Clause	SQL
8	Sql query to use BETWEEN Operator	SQL
9	Sql Query To Update Single Record	SQL
10	Sql Query to use a Not Null Constraint	SQL
11	Sql Query To Use a ' SELECT ' statement with LIMIT	SQL
12	Sql Query To Use a ' SELECT ' statement with the MIN() or MAX() function.	SQL
13	Sql Query To Use a ' SELECT ' statement with AND Operator	SQL
14	Sql Query To Update Multiple Column	SQL
15	Sql Query To Use a ' SELECT ' statement with SUM() function.	SQL
16	Sql Query To Insert The Record In The Table By Defining The Column Name	SQL
17	Sql Query To Insert The Record In The Table Without Defining The Column Name.	SQL
18	Sql Query to Delete Records	SQL
19	Sql Query To Use a ' SELECT ' statement with HAVING Clause	SQL
20	Sql Query To Use a ' SELECT ' statement with OR Operator	SQL
#	Program	Language

Sql Query To Use a ' SELECT ' statement with Alias or 'AS"

Similar Program

About Fresherbell

Important Links

Social Media