select*from(select rownum rn,sal from(select*from emp order by sal desc))wh

Find out the 3rd highest salary?

Question Posted / kumar

Answer Posted / kumar

select*from(select rownum rn,sal from(select*from emp order by sal desc))where rn=3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how is exception handling handled in mysql? : Sql dba

1009

How to take user input in pl sql?

1107

Which is better stored procedure or query?

922

What is a temporal table?

882

What is graph sql?

938

What is a pragma statement?

1204

How can triggers be used for the table auditing?

1012

What is union and union all keyword in sql?

972

How can we debug in PL/SQL?

1094

Explain sql data types?

1037

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

906

Explain the purpose of %type and %rowtype data types with the example?

929

How do I run sql?

1096

Explain commit, rollback and savepoint.

933

Explain spool.

1114