查询最大值:
select * from TRADE_ORDER where order_amt=(select max(order_amt) from TRADE_ORDER)
查询最小值:
select * from TRADE_ORDER where order_amt=(select min(order_amt) from TRADE_ORDER)
子查询
1. 例:查询出销售部的员工的姓名,工作,工资
Select ename,job,sal from emp where deptnoo=(select deptno from dept where dname=’sales’)
内部查询的结果作为外部查询的条件
2. 例:查询出emp表中比任意一个销售员工资低的员工姓名,工作,工资
Select ename,job,sal from emp where sal<any(select sal from emp where job=’salesname’)
Any放在比较运算符后面,表示