MySQL MAX Function: Examples

SELECT 
    MAX(amount)
FROM
    payments;

SELECT 
    *
FROM
    payments
WHERE
    amount = (
		SELECT 
            MAX(amount)
        FROM
            payments);

SELECT 
    *
FROM
    payments
ORDER BY amount DESC
LIMIT 1;

SELECT 
    customerNumber, MAX(amount)
FROM
    payments
GROUP BY customerNumber
ORDER BY MAX(amount);

SELECT 
    customerNumber, MAX(amount)
FROM
    payments
GROUP BY customerNumber
HAVING MAX(amount) > 80000;

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;