MySQL MIN Function: Examples

Examples
Sample Database

#1

SELECT 
    MIN(buyPrice)
FROM
    products;

#2

SELECT 
    productCode, productName, buyPrice
FROM
    products
WHERE
    buyPrice = (
        SELECT 
            MIN(buyPrice)
        FROM
            products);

#3

SELECT 
    productline, MIN(buyprice)
FROM
    products
GROUP BY productline;

#4

SELECT 
    productline, productCode, productName, buyprice
FROM
    products a
WHERE
    buyprice = (
        SELECT 
            MIN(buyprice)
        FROM
            products b
        WHERE
            b.productline = a.productline);

#5

SELECT 
    a.productline, a.productCode, a.productName, a.buyprice
FROM
    products a
        LEFT JOIN
    products b ON a.productline = b.productline
        AND b.buyprice < a.buyprice
WHERE
    b.productcode IS NULL;

Table List

customers

SELECT * FROM customers;

employees

SELECT * FROM employees;

offices

SELECT * FROM offices;

orderdetails

SELECT * FROM orderdetails;

orders

SELECT * FROM orders;

payments

SELECT * FROM payments;

productlines

SELECT * FROM productlines;

products

SELECT * FROM products;

Result