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 name query output columns in oracle?

694

How to delete an existing row from a table in oracle?

651

Explain the different normalization forms?

601

What to do if dba lost the system password?

606

What is a cognitive schema?

531

What are the built-in functions used for sending Parameters to forms ?

2850

How to display employee records who gets more salary than the average salary in the department?

603

What is max rowid in oracle?

563

Explain the use of full option in exp command.

593

What are the differences between char and varchar2 in oracle?

569

What is the difference between "as" and "is" in an oracle stored procedure?

546

What is key preserved table?

570

Explain how are indexes update?

630

What is a lookup table in oracle?

551

How do we get field detail of a table?

633