select min(sal) from (Select rownum,sal FROM emp> Order by sal desc)

Find out the 3rd highest salary?

Question Posted / durgashivashankar

Answer Posted / durgashivashankar

select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is cascade in sql?

933

what is sql? : Sql dba

982

What is the use of count (*) in sql?

1004

Is postgresql a server?

1013

How do I remove sql plus from windows 10?

1046

Where is sql database stored?

939

What is pivot table in sql?

1046

What is count * in sql?

963

What are different categories of sql commands?

1094

Explain some predefined exceptions.

1003

Which table is left in join?

927

What is a composite primary key?

1050

How do I view tables in mysql?

929

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

1152

What are inbuilt functions in sql?

1013