oracle 查询列值相同其他信息的信息

 SQL> select ename,sal from emp where sal in (select sal from (select count(*) as sals ,sal from emp group by sal) where sals>=2); ENAME            SAL---------- ---------MARTIN       1250.00WARD         1250.00zhulei%l    10000.00zhulei      10000.00FORD         3000.00SCOTT        3000.00 6 rows selected

?下面有所要查询的sql包