oracle之all, any,

来源:互联网 发布:学汽修下载什么软件? 编辑:程序博客网 时间:2024/06/03 19:57

1、all

select * from emp where sal > all (select sal from emp);

等于 select * from emp where sal> (select max (sal) from emp);

2、any

select * from emp where sal> any(select sal from emp);

等于 select * from emp where sal >(select min(sal) from emp);

 

原创粉丝点击