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

Find out the 3rd highest salary?

Question Posted / xyz

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

Please Help Members By Posting Answers For Below Questions

what is try_catch block in procedure

1753

Where is all the data on the internet stored?

1015

explain access control lists. : Sql dba

1003

Can cursors be part of a trigger body?

1641

How to convert comma separated string to array in pl/sql?

1187

What is keys and its types?

1075

What is secondary key?

935

how can you create an empty table from an existing table? : Sql dba

1156

Can you have more than one trigger on a table?

1003

What do you understand by exception handling in pl/sql?

1035

What are the types of records?

988

Are views faster than queries?

992

Explain what is a database?

1087

What is the current version of postgresql?

1070

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2016