select *

from emp

where sal>(select sal

                    from emp

                     where ename='SCOTT');