Oracle练习:有关Oracle用户scott的sql练习

1、列出薪金比“SMITH”多的所有员工。
select *from emp where sal+nvl(comm,0)>(select sal+nvl(comm,0) from emp where ename='ALLEN'); select *from emp where