Why is the AS Clause Used in SQL?

Why is the AS Clause used in SQL?

We use the AS clause in SQL to give a new name to a column or a table in a database. This name is known as an alias, and it is used to make the column or table name more readable. The alias exists only for the duration of the query. When multiple queries are to be made for a single table, we use an alias for that table to speed up the process.

The AS Clause helps to shorten the queries, thus improving code readability and understandability.

Why is the AS clause used in SQL?

The AS Clause in SQL is used for temporary renaming operations.

Now, you might wonder why shall we need to rename our tables or columns.

• By temporarily renaming a column or table, we can get a better presentation of query results and create more user-friendly queries without permanently changing the name of the column or the table.
• Giving short and concise names to the columns and tables is particularly useful when the queries become large and complex or contain many joins.
• Working with long and incomprehensible table and column names can be extremely exhausting and time-consuming. In such cases, meaningful alias can speed up the work and improve code readability.
• We can avoid retyping the long table and column names every time we have to access them by using short temporary names to suit our needs.

Where is the AS clause used in SQL?

The AS Clause is used along with the SELECT Statement in SQL.

We use the SELECT statement to select some data from our database. The AS Clause is also used to specify that we want to select some data (e.g., a column) as our alias name. This alias is the temporary name we assign to the data (column). This name will exist only for the duration of the query.

Let us see the syntax for AS Clause in SQL.

AS Clause for Column Syntax

AS Clause for Table Syntax

Examples for AS clause in SQL

We are creating a table called College_Students which stores the following data for each student - ID, Name, Branch, Country, City, and Age.

We use the CREATE TABLE command to create the table and the INSERT command to insert each row of student data.

The Table:

Let us now go through various examples demonstrating the use of AS Clause with the help of the above table.

EXAMPLE 1:

Write a query to get the student ID and the student name under the temporary column name 'ID' and 'Name', respectively.

Result:

Explanation:

Here we are creating an alias for two columns using AS Clause. In the result table, the column names now appear as the alias names, 'ID' and 'Name'.

EXAMPLE 2:

Write a query to get the City and the Country name under the temporary column name 'Address', along with each Student ID.

Let us see the result of the above SQL Query:

Explanation:

Here we are appending the country and city for each student into a single column, whose alias is 'Address'.

EXAMPLE 3:

Write a query to get the name of all students as "Name" from an alias of the above table named "s"

Result:

Explanation:

Here we are creating an alias of the above table named 's'. Then from 's', we select the column STUDENT_NAME under the alias 'Name'.

EXAMPLE 4:

Create another table that contains records of students who have backlogs. Write a query to get the data of students present in the above table who have their records in the Backlogs Table. Use Alias for Column and Table Names.

We create a table named Students_With_Backlogs to store the Student_ID, Student_Backlogs, and GPA of the students with backlogs.

Let us view the above table.

SQL Query:

Result:

Explanation:

We are selecting those records from the Students_With_Backlogs (alias is b) table whose student id is also present in College_Students (alias is c) table. We are displaying the STUDENT_NAME as 'names', and STUDENT_BACKLOGS as 'fails' in our result table, using the AS Clause.

Learn more about Clauses in SQL

You can learn more about clauses in SQL from the below resource: SQL Query Execution Order