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

Is sql microsoft?

1062

What is a dirty read sql?

1168

What is partition in sql query?

1011

Can you load data into multiple tables at once? : aql loader

1082

What is function and procedure?

1040

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1220

Explain sql data types?

1107

how to escape special characters in sql statements? : Sql dba

1048

What is rename in sql?

980

What is dba in sql? : SQL DBA

1050

Mention what plvcmt and plvrb does in pl/sql?

1149

what are the t string functions available in tsql? : Transact sql

1021

What is loop in pl sql?

1043

Is merge a dml statement?

988

What is over () in sql?

973