如何找出EMP表里面SALARY第N高的employee
2023-07-06
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal
如何找出EMP表里面SALARY第N高的employee2023-07-06 SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal 相关内容: |