CASE expression in SQL
Nguyễn Viết Thông
1:00 PM
Cú pháp: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 WHEN conditionN THEN resultN ...
Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts
Tuesday, October 3, 2023
INSERT INTO SELECT statement in SQL
Nguyễn Viết Thông
12:30 PM
Cú pháp câu lệnh: INSERT INTO table2 ( column1 , column2 , column3 , ...) SELECT column1 , column2 , column3 , ... FROM tabl...
SELECT INTO statement in SQL
Nguyễn Viết Thông
12:00 PM
Cú pháp câu lệnh: SELECT column1 , column2 , column3 , ... INTO newtable [ IN externaldb ] FROM oldtable WHERE condition; Ví...
ANY and ALL operators in SQL
Nguyễn Viết Thông
11:30 AM
Cú pháp câu lệnh: ANY SELECT column_name(s) FROM table_name WHERE column_name operator ANY ( SELECT column_name FROM tabl...
EXISTS operator in SQL
Nguyễn Viết Thông
11:00 AM
Cú pháp câu lệnh: SELECT column_name(s) FROM table_name WHERE EXISTS ( SELECT column_name FROM table_name WHERE condition ...
HAVING in SQL
Nguyễn Viết Thông
10:30 AM
Cú pháp câu lệnh: SELECT column_name(s) FROM table_name WHERE condition GROUP BY column_name(s) HAVING condition ORDER BY ...
GROUP BY statement in SQL
Nguyễn Viết Thông
10:00 AM
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í...
UNION operator in SQL
Nguyễn Viết Thông
9:30 AM
Cú pháp: SELECT column_name(s) FROM table1 UNION SELECT column_name(s) FROM table2 ; SELECT column_name(s) FROM table1 U...
Self Join in SQL
Nguyễn Viết Thông
9:15 AM
Cú pháp: SELECT column_name(s) FROM table1 T1, table1 T2 WHERE condition ; Ví dụ: SELECT A.CustomerName AS CustomerName1, B.Cus...
RIGHT JOIN in SQL
Nguyễn Viết Thông
9:00 AM
Cú pháp: SELECT column_name(s) FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name ; Ví dụ: SELECT Ord...
LEFT JOIN in SQL
Nguyễn Viết Thông
8:45 AM
Cú pháp: SELECT column_name(s) FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name ; Ví dụ: SELECT Cust...
