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 trigger in sql? Explain

1006

how is exception handling handled in mysql? : Sql dba

1094

How do I delete a trigger?

973

What is the difference between inner join and outer join?

1005

How can check sql version from command line?

1098

What is a sql select statement?

1045

What is duration in sql profiler trace?

1093

Explain lock escalation? : Transact sql

1212

How many tables can you join in sql?

972

How to prepare for oracle pl sql certification?

1081

How can we make an if statement within a select statement?

1026

What is latest version of sql?

1057

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1029

Can we insert delete data in view?

956

What is the maximum number of triggers, you can apply on a single table?

1010