select a.sal from (select distinct(sal) from emp order by sal desc)a where

Find out the 3rd highest salary?

Question Posted / xyz

51 Answers
73484 Views
BirlaSoft, DAC, Silvia Infotech, Sutra Infotech, I also Faced
E-Mail Answers

Answer Posted / xyz

select a.sal from (select distinct(sal) from emp order by
sal desc)a where rownum=3

Is This Answer Correct ?

2 Yes

7 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Show the cursor attributes of pl/sql.

1026

What information is needed to connect sql*plus an oracle server?

1005

Is join and inner join the same?

989

What is sql character function?

1051

What are different methods to trace the pl/sql code?

1093

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1817

Are pl sql variables case sensitive?

1031

What does dml mean?

964

What does pl sql developer do?

912

Can we rollback truncate?

985

what is the difference between clustered and non clustered index in sql? : Sql dba

1105

What is the difference between having clause and where clause?

1046

Can a procedure in a package be overloaded?

1027

Differentiate pl/sql and sql?

1051

How do you optimize a stored procedure in sql?

925