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

What happens to the data files if a tablespace is dropped?

996

what are steps for interface? where is exchange rate defined in which table?

2058

what is the difference between substr and instr function in oracle?

1036

How to delete a column in an existing table in oracle?

1011

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

977

What is coalesce function?

1009

What is data type in oracle?

1043

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1010

What is SQL Tuning Advisor in Oracle?

1109

How do I recompile a procedure in oracle?

912

Explain a synonym?

971

How to start your 10g xe server?

970

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1846

Please explain oracle left join with an example?

960

What is an oracle and why it is used?

1080