🌟 Understanding SQL Aliases: A Beginner-Friendly Guide with Examples

.

🧑‍🏫 Introduction to SQL Aliases

When you run SQL queries, sometimes the column or table names are too long, not user-friendly, or unclear in the result set. That’s where aliases come in.

An alias in SQL is a temporary name that you give to a column or a table. It helps in:

• Making your query results more readable

• Renaming calculated columns

• Shortening long table names, especially in JOINs

👉 Think of an alias as a nickname you give for a short time — just while the query is running.

---

🔹 Why Use Aliases?

---

🛠️ Let’s Build It Step-by-Step

We’ll use two simple tables:

• Products: List of items

• Orders: Sales made for those items

---

🧱 Step 1: Create the Products Table

CREATE TABLE Products (
    ProductID INT PRIMARY KEY,
    ProductName VARCHAR(50),
    Price DECIMAL(10, 2)
);

---

➕ Step 2: Insert Sample Data

INSERT INTO Products (ProductID, ProductName, Price)
VALUES 
(1, 'Pen', 10.00),
(2, 'Pencil', 5.00),
(3, 'Eraser', 3.00);

Our Products table now looks like this:

---

🏷️ Step 3: Column Aliases

Let’s say you want to show ProductName as just Name, and Price as Cost. You can do:

SELECT ProductName AS Name, Price AS Cost
FROM Products;

✅ Output:

💡 Tip: The AS keyword is optional, so you could write:

SELECT ProductName Name, Price Cost FROM Products;

But using AS makes your code clearer.

---

📊 Step 4: Alias for Calculated Columns

Let’s say you want to double the price and show it as a new column.

SELECT ProductName, Price * 2 AS DoublePrice
FROM Products;

✅ Output:

---

📁 Step 5: Create a Second Table - Orders

Now let’s create a related table called Orders that references Products.

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    ProductID INT,
    Quantity INT,
    FOREIGN KEY (ProductID) REFERENCES Products(ProductID)
);

---

➕ Insert Orders Data

sqlCopyEditINSERT INTO Orders (OrderID, ProductID, Quantity)
VALUES 
(101, 1, 2),  -- Pen
(102, 2, 5),  -- Pencil
(103, 3, 1);  -- Eraser

---

🔗 Step 6: Table Aliases with JOINs

Now suppose you want to display the order details along with product names. Using table aliases makes your query shorter and cleaner.

SELECT o.OrderID, p.ProductName, o.Quantity, p.Price AS UnitPrice
FROM Orders AS o
JOIN Products AS p ON o.ProductID = p.ProductID;

Here:

• o is an alias for Orders

• p is an alias for Products

• p.Price AS UnitPrice gives the column a friendly name

✅ Output:

---

✅ Summary: What You Learned