select * from emp where &n=(select count(distinct(sal)) from emp b wh

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

Question Posted / nusrath sultana

Answer Posted / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between $oracle_base and $oracle_home?

1084

How to define an oracle cursor variable?

1027

When do I need to use a semicolon vs a slash in oracle sql?

1088

How data locks are respected in oracle?

1065

How to delete a column in an existing table?

1072

What are the attributes of the cursor?

1000

How to find out what oracle odbc drivers are installed?

1040

How to define default values for formal parameters?

1042

What are the different types of trigger and explain its various uses and functions?

1087

How to call a stored function with parameters?

1035

Query to retrieve record for a many to many relationship ?

2516

What are the ansi data types supported in oracle?

944

How to connect asp pages to oracle servers?

1072

What do you mean by redo log file mirroring?

1024

How to export data to a csv file?

1297