维博520
2020-06-20 阅读量: 646
-- 查询基本工资高于30号部门任意员工的员工信息
select * from emp where sal>(select min(sal) from emp group by deptno having deptno=30) and deptno <>30;