Using MySQL Alias To Make The Queries More Readable: Examples

Back Home

Examples
Sample Database

#1

SELECT 
    CONCAT_WS(', ', lastName, firstname)
FROM
    employees;

#2

SELECT 
    CONCAT_WS(', ', lastName, firstname) AS `Full name`
FROM
    employees;

#3

SELECT 
    CONCAT_WS(', ', lastName, firstname) `Full name`
FROM
    employees
ORDER BY `Full name`;

#4

SELECT 
    orderNumber `Order no.`,
    SUM(priceEach * quantityOrdered) Total
FROM
    orderdetails
GROUP BY `Order no.`
HAVING total > 60000;

#5

SELECT 
    customerName, COUNT(o.orderNumber) total
FROM
    customers c
        INNER JOIN
    orders o ON c.customerNumber = o.customerNumber
GROUP BY customerName
ORDER BY total DESC

#6

SELECT 
    customers.customerName, COUNT(orders.orderNumber) total
FROM
    customers
        INNER JOIN
    orders ON customers.customerNumber = orders.customerNumber
GROUP BY customerName
ORDER BY total DESC

Table List