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 retrieve values from data fields in record variables?

1109

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2963

how to do daily transactions with out sql* loader control file regesterd in apps?

1683

What is a synonym? What are its various types?

1106

What is a sub query? Describe its types?

1015

What are the types of partitions in oracle?

1034

What are triggers in oracle?

1032

What are the different pseudo commands? Explain in general?

1073

When do we use group by clause in a sql query?

1035

How to compare dates in oracle sql?

1097

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

1030

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

Explain the use of full option in exp command.

1113

Explain joins in oracle?

1033

Explain the function of optimizer in oracle?

1139