SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT

how to find the n'th highest salary from emp ?

Question Posted / brajesh kumar

Answer Posted / brajesh kumar

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Is This Answer Correct ?

15 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to load a large xml file?

1059

Hi Can any one tell me what are the API's used in requisition import.

1926

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

1944

Is there any function in oracle similar like group_concat of mysql?

1057

What is a trigger and what are its types in oracle?

1079

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

How to create a temporary table in oracle?

1275

What is format trigger?

2077

What are the execution control statements?

1071

What is difference between truncate and delete?

1047

How to get a list of all background sessions in the database?

993

How to create a server parameter file?

1141

Is oracle a programming language?

995

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1054

How can we force the database to use the user specified rollback segment?

1152