Oracle篇 之 子查询

子查询：先执行内部再外部

Select last_name,salary,dept_id

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

From s_emp

Where dept_id in (

Select dept_id

From s_emp

Where dept_id is not null

);

 

Select last_name,dept_id

From s_emp

Where dept_id = (

Select dept_id

From s_emp

Where last_name=’Smith’

);

 

Select salary,last_name

From s_emp

Where salary<(

Select avg(salary)

From s_emp

);

 

Select last_name,dept_id,title

From s_emp

Where dept_id =(

Select dept_id

From s_emp

Where last_name=’Smith’

) and tltle = (select tltle

From s_emp

Where last_name=’Smith’

);

 

Select rownum,last_name,salary

From s_emp

Where rownum<=20

minus

Select rownum,last_name,salary

From s_emp

Where rownum<=10

;

扫码关注我们

微信号：SRE实战

拒绝背锅 运筹帷幄