SQL SELECT AS – Column and Table Aliases in SQL

SQL SELECT AS (Aliases)

SQL AS assigns temporary names (aliases) to columns or tables. It improves readability and presentation without altering the underlying database structure. Aliases live only for the duration of the query.

Complete Python Course with Advance topics:-
SQL Tutorial:-

Syntax

SELECT Column1 AS New_Name1,
       Column2 AS New_Name2
FROM Table_Name;

Example 1: Renaming Columns

SELECT Order_Date AS Purchase_Date,
       Buyer AS Customer, Item, Quantity
FROM purchases;

Example 2: AS with Aggregates

SELECT Name AS Student,
       AVG(Marks) AS Average_Marks
FROM students;

Example 3: AS with CONCAT

SELECT Roll_No AS Student_ID,
       CONCAT(Mobile, ', ', City) AS Student_Info
FROM students;

Table Aliases

Table aliases make queries shorter and JOINs cleaner. The AS keyword is optional for table aliases:

SELECT s.Roll_No, s.Name, s.City
FROM students AS s
WHERE s.Roll_No = 3;

Download New Real Time Projects:- Click here
Complete Advance AI topics:-

Conclusion

Aliases via AS make query results cleaner and JOIN queries shorter. Use them generously for readable, maintainable SQL. For more tutorials, stay connected with .

sql alias
sql alias in where clause
group by sql alias
sql as table
sql table alias join
sql select as example
sql select as column
sql select as w3schools