Technical Discussion :: Informatica
Home > Technical Interview Q&A > Informatica > Discussion
10 / 94
How to found 7th max salary without using top function.
Answer:
How to find 7th highest salary in Oracle SQL.
TABLE NAME: EMP
SELECT * FROM EMP E1 WHERE 7=(SELECT COUNT(DISTINCT(SALARY)) FROM EMP E2 WHERE E2.SALARY>=E1.SALARY);
Asked In ::
Pintu Kumar
23 Feb, 2019 5:07 AM
How to find 7th highest salary in Oracle SQL.
TABLE NAME: EMP
SELECT * FROM EMP E1 WHERE 7=(SELECT COUNT(DISTINCT(SALARY)) FROM EMP E2 WHERE E2.SALARY>=E1.SALARY);