Assuming that EMP table with Sal column SELECT MIN(sal) FROM (SELECT

how to find the fifth highest salary?

Question Posted / chandra shekhar

8 Answers
12731 Views
IBM, Infosys, I also Faced
E-Mail Answers

Assuming that EMP table with Sal column

SELECT MIN(sal) FROM
(SELECT DISTINCT sal FROM emp WHERE
ROWNUM < 6
ORDER BY sal DESC )

- If fifth highest then ROWNUM < 6
- If n'th highest then ROWNUM < n+1

Regards
J

Is This Answer Correct ?

11 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about the return statement?

882

What is 2 tier 3 tier architecture?

848

What is 2NF?

845

What is temp db database? : sql server architect

889

What are the primitive operations common to all record management systems?

981

State about the security aspects of stored procedures?

976

What are the levels of architecture?

809

What do data architects do?

826

What is the difference between stored procedures and stored functions in oracle?

938

What is internal database?

988

can we use transformer in datastage without any input link?

1745

What is a Database system?

870

What are page splits? : sql server architect

907

What is "transparent DBMS"?

863

What is a query?

880