select * from ( select * from (select * from emp order by sal desc) whe

Find out the 3rd highest salary?

Question Posted / sachin

Answer Posted / sachin

select * from ( select * from (select * from emp order by
sal desc)
where rownum<=3
order by rownum desc)
where rownum=1

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

List the various privileges that a user can grant to another user?

987

how to shut down the server with 'mysqladmin'? : Sql dba

954

What do you mean by stored procedures? How do we use it?

928

What is sql server and ase?

975

What is range partitioning?

911

What is data control language?

946

What is sql partition function?

1116

How do you rename a table in sql?

1028

What is an example of translating a date into julian format?

1037

What steps server process has to take to execute an update statement?

919

How to take user input in pl sql?

1105

What is self-join and what is the requirement of self-join?

1088

how do you tune the slow running queries in oracle db , explain the methodology

2057

What is offset in sql query?

1068

What is time based sql injection?

900