摘要:
问:查找出收入(工资加上奖金),下级比自己上级还高的员工名字?这个题看是简单,但是在我第一次写sql语句的sql就没有成功,我是这样写的: select a.ename from emp a, emp b where a.empno = b.mgr and (a.sal + nvl(a.comm,0)) > (b.sal + nvl(b.comm,0));查询结果是:这个是错误的,正确的sql是: select a.ename from emp a, emp b where a.mgr = b.empno and (a.sal + nvl(a.comm,0)) > (b.sal + 阅读全文