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

How to use windows user to connect to the server?

990

Differentiate between function and procedure in oracle.

1086

What is the minimum client footprint required to connect c# to an oracle database?

1098

How to change program global area (pga) in oracle?

1096

How to define and use table alias names in oracle?

945

How many categories of data types?

997

How do you bind variables in oracle?

985

List the types of joins used in writing subqueries?

998

How do I find my oracle client driver version?

1045

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 can I create database in oracle?

1030

Explain an index segment?

1124

How to use "for" statements in oracle?

1076

How much memory your 10g xe server is using?

1106

Differentiate between pre-select and pre-query?

1115