2、union:默认地,UNION 操作符选取不同的值;如果允许重复的值,请使用 UNION ALL。
example:
SELECT E_Name FROM Employees_China
UNION
SELECT E_Name FROM Employees_USA
3、单引号不乱用
4、desc降序,asc升序
5、group by........having.............
6、case when.....then.....else......end
example:SELECT grade, COUNT (CASE WHEN sex = 1 THEN 1 /*sex 1为男生,2位女生*/
ELSE NULL
END) 男生数,
COUNT (CASE WHEN sex = 2 THEN 1
ELSE NULL
END) 女生数
7、内连接(inner join)
select .........from............where ...=.... and........
8、XXX (inner join XXXX on .......) inner join XXXXXXX on..........