Code và Chia sẻ

Monday, October 2, 2023

Cấu trúc: SELECT column_name(s) FROM table_name WHERE column_name BETWEEN value1 AND value2; Ví dụ: SELECT * FROM Produc...

Câu lệnh: SELECT column_name(s) FROM table_name WHERE column_name IN ( value1 , value2 , ...); Ví dụ: SELECT * FROM Custome...

Câu lệnh: SELECT column1, column2, ... FROM table_name WHERE columnN LIKE pattern ; Ví dụ: SELECT * FROM Customers WHERE C...

Câu lệnh: SELECT AVG( column_name ) FROM table_name WHERE condition ; Ví dụ: SELECT AVG(Price) FROM Products WHERE CategoryID = ...

Câu lệnh: SELECT SUM( column_name ) FROM table_name WHERE condition ; Ví dụ: SELECT SUM(Quantity) FROM OrderDetails WHERE Prodic...

Cú pháp câu lệnh: SELECT COUNT ( column_name ) FROM table_name WHERE condition ; Ví dụ: SELECT COUNT (ProductID) FROM Products ...