select * from emp5 where salary in(select min(salary) from emp5 where sal

find out the third highest salary?

Question Posted / vanaja

Answer Posted / vanaja

select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to assign data of the deleted row to variables?

1118

What is the relation of a user account and a schema in oracle?

1127

Can I create users through internet explorer in oracle 10g?

1158

What is the use of oracle?

1078

How to drop an existing view in oracle?

992

How to connect asp pages to oracle servers?

1121

Give syntax for SQL and ORACLE joins.

1146

Does oracle charge for java?

1115

How do I reset a sequence in oracle?

1155

What is difference between sid and service name in oracle?

1018

What is an oracle transaction?

1229

What are the limitations of check constraint?

1076

What is a table index in oracle?

1187

What is meant by a deadlock situation?

1156

Is the After report trigger fired if the report execution fails ?

2955