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包
