SQL Aliases Explained with Example alias in sql query

SQL TUTORIALS-

SQL Aliases Explained with Example alias in sql query

Introduction-

✅What is an Alias in SQL?

✅SQL Aliases are used to rename columns or tables temporarily in a query for better readability. is use In SQL, an alias is an alternative name used to temporarily rename a column or a table in a query. Aliases make your SQL statements more readable, cleaner, and easier to understand (example)-alies created and use AS keyword, although using AS is optional in many databases example- MySQL, PostgreSQL, or SQL Server.

🔸 Example Table: Employee

✅ Example 1: Column Alias-

SELECT emp_name AS Name, salary AS "Monthly Salary"
FROM employee;

✅Result Show :-

Result → ANNI | 20000 | SUJAN | 25000 | BOULT | 30000 | POOJA | 35000

✅ Example 2: Alias with Expression (Calculating Annual Salary)-

SELECT name, salary * 12 AS "Annual Salary"
FROM employee;

✅Result Show :-

Result → ANNI | 240000 | SUJAN | 300000 | BOULT | 360000 | POOJA | 420000

✅ Example 3: Alias Without AS Keyword-

SELECT name Name, department Dept
FROM employee;

✅Result Show :-

Result → use an alias without the AS keyword, though it's optional and sometimes discouraged for clarity it.

✅ 4. Table Alias in JOIN-

SELECT e.emp_name, d.dept_location
FROM employee e
JOIN department d ON e.department = d.dept_name;

✅Result Show :-

Result → e and d are aliases for employee and department tables.

May Be Like Important Link-

-SQL Tutorial for Beginners – Introduction to SQL

-SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause

-SQL SELECT DISTINCT Statement Clause Explained with Examples

-SQL Wildcard Characters: Complete Guide with Examples