删除emp表的语句是什么
删除emp表的语句是“delete from emp where (deptno,sal) in (select deptno,max(sal) from emp group by deptno);commit;”。推荐：《oracle教程》oracle数据库删除emp表从emp表中删除各个部门中具有最高工资的员工。删除语句是：12delete from emp where (deptno,sal) in (select deptno,max(sal) from emp group by deptno);