Explain ALIAS in SQL?

1.	Explain ALIAS in SQL?
Answer» It is used to RENAME a table in a specific SQL statement. Renaming is a temporary CHANGE without change actual table NAME in the database. It can be applied to tables as well as fields. The BASIC SYNTAX of a table alias SELECT field1, field2 FROM TABLE_NAME AS TABLE WHERE "WRITE_YOUT_CONDITION"; The basic syntax of a column alias SELECT field1 AS column1 FROM TABLE_NAME WHERE "WRITE_YOUT_CONDITION";

Answer»

It is used to RENAME a table in a specific SQL statement. Renaming is a temporary CHANGE without change actual table NAME in the database. It can be applied to tables as well as fields.

The BASIC SYNTAX of a table alias
SELECT field1, field2 FROM TABLE_NAME AS TABLE WHERE "WRITE_YOUT_CONDITION";

The basic syntax of a column alias
SELECT field1 AS column1 FROM TABLE_NAME WHERE "WRITE_YOUT_CONDITION";

Discussion

No Comment Found

Related InterviewSolutions

What has stored procedures in SQL and how we can use it?
How to use distinct and count in SQL query? Explain
Explain CLAUSE in SQL?
Write a query to find the names of users that begin with "um" in SQL?
Explain the difference between DROP and TRUNCATE commands in SQL?
Write a query to display the current date in SQL?
Explain Foreign key in SQL?
Explain Unique key in SQL.
Explain table and field in SQL?
What is a Database? Explain

Explain ALIAS in SQL?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment