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

What is the difference between pre-select and pre-query?

1123

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

975

Can objects of the same schema reside in different tablespace?

1000

How would you best determine why your MVIEW couldnt FAST REFRESH?

1835

What is execute immediate in oracle?

949

How to find the duplicate rows count from employees table in oracle?

1038

What do you understand by database schema and what does it hold?

1177

How to use "if" statements on multiple conditions?

1111

How to drop a stored procedure in oracle?

996

What is a relational database management system?

1062

What is the difference between alert log file and tarce file ?

2096

Is primary key indexed by default in oracle?

929

What is a dead lock in oracle?

1048

How to recover a dropped table in oracle?

983

What is an external table?

957