select * from (select sal, rownum r from Employee order by sal desc) wher

find out the third highest salary?

Question Posted / chandiran

Answer Posted / chandiran

select * from (select sal, rownum r from Employee
order by sal desc)
where r=3

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why do we need oracle client?

956

What is a subquery in oracle?

1112

What happens if you set the sga too low in oracle?

1155

What is oracle datasource?

993

Can a formula column referred to columns in higher group ?

2506

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2278

What is redo log?

1070

How many types of segments in Oracle?

1071

What is the usage of merge statement?

1154

What is an Oracle index?

1657

How to pass parameters to procedures in oracle?

1042

How to load data from external tables to regular tables?

1062

What is the recommended interval at which to run statspack snapshots, and why?

2921

How to do clean up if create database failed?

1031