[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.
Technical Discussion :: Informatica

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 ::

Post Your Answer Here:


Rate This: +0 -0     
Report    

Post Your Reply Here:

Alert me
q4i-reply-your-answer

Report Error

Please Login First Click Here

Most Popular Qs.