Monday, October 2, 2023

SUM function in SQL

 

Câu lệnh: 

SELECT SUM(column_name)
FROM table_name
WHERE condition;

Ví dụ: 

SELECT SUM(Quantity)
FROM OrderDetails
WHERE ProdictId = 11;

Ví dụ: 
SELECT SUM(Quantity)
FROM OrderDetails;