立即学习:https://edu.csdn.net/course/play/25219/294553?utm_source=blogtoedu
子查询
select *from emp where sal > (select sal from emp where ename = ‘SCOTT’)
子查询可以出现的位置:where、select(常量列)、having、from;不能写在group by 后面
立即学习:https://edu.csdn.net/course/play/25219/294553?utm_source=blogtoedu
子查询
select *from emp where sal > (select sal from emp where ename = ‘SCOTT’)
子查询可以出现的位置:where、select(常量列)、having、from;不能写在group by 后面