Code và Chia sẻ

Tuesday, October 3, 2023

Cú pháp câu lệnh: SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) ORDER BY column_name(s); Ví...

Cú pháp: SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2 ; SELECT column_name(s) FROM table1 U...

Cú pháp: SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition ; Ví dụ: SELECT A.CustomerName AS CustomerName1, B.Cus...

Cú pháp: SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name ; Ví dụ: SELECT Ord...

Cú pháp: SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name ; Ví dụ: SELECT Cust...

Cú pháp: SELECT column_name(s) FROM table1 FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condit...