多表查询
横向连接查询
inner join
例: select * from t1 inner join t2 on t1.key1=t2.key2;
right join
left join
纵向合并查询
union
例: select * from t1 union select * from t2;
union all
子查询
select *
from emp
where sal > (select avg(sal) from emp);
in
not in
any
窗口函数
该课程属于 CDA LEVEL 1认证考试冲刺培训与模拟 请加入后再学习
App下载
官网微信
