Monday, October 2, 2023

Home / SQL / MIN and MAX functions in SQL

MIN and MAX functions in SQL

on 8:00 PM in SQL

Cú pháp câu lệnh:

SELECT MIN(column_name)
FROM table_name
WHERE condition;

SELECT MAX(column_name)
FROM table_name
WHERE condition;

Ví dụ:

SELECT MIN(Price) AS SmallestPrice
FROM Products;