Best One select top 1 * from test_emp where sal in (select top 3 sal fr

find out the third highest salary?

Question Posted / haneef

92 Answers
150720 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / haneef

Best One

select top 1 * from test_emp where sal in (select top 3 sal
from test_emp order by sal desc) order by sal asc

or

It also work

select top 1 * from test_emp where sal in (select top 3 sal
from test_emp order by sal desc) order by sal asc
select top 1 MAX(sal),id from test_emp where sal < (select
max(sal) from test_emp where sal < (select max(sal) from
test_emp))
group by id,sal order by sal desc

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an oracle wallet?

942

Explain oracle data types with examples?

1025

How to retrieve data from an cursor to a record?

1100

What is ADDM Advisor in Oracle?

1171

What is the difference between hot backup and cold backup in oracle?

1010

How to write text literals in oracle?

1066

Why is oracle used?

937

What is a oracle database?

1053

What are the differences between char and nchar in oracle?

1094

What are temporal data types in oracle?

1121

How to create an oracle database manually?

1085

What is the string concatenation operator in oracle?

1175

what are bitmap indexes? How does they work?

2237

How to create a new table in oracle?

1151

How to retrieve the count of updated rows?

1126