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

Does mysql support pl sql?

1143

What are the types of variable use in pl sql?

1055

How many columns should be in an index?

950

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1545

i have some prob lem to tell me about my self in interview first round ...

2150

What is difference sql and mysql?

966

Can we insert data in view?

947

When you have to use a default "rollback to" savepoint of plvlog?

1170

What is before and after trigger?

932

discuss about myisam index statistics collection. : Sql dba

937

How do I delete a trigger?

945

What is cte sql?

971

How do I know if I have sql express or standard?

1013

what are date and time data types in mysql? : Sql dba

953

Explain the working of primary key?

1073