select min(sal) from (select sal from (select sal from salary order by sa

Find out the 3rd highest salary?

Question Posted / tathagoto

Answer Posted / tathagoto

select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is embedded sql with example?

989

What is numeric function sql?

988

What is spool?

993

How can you get sql*loader to commit only at the end of the load file? : aql loader

967

Is inner join same as self join?

1064

What is a nested table in word?

911

Can you have more than one key in a database?

893

What is a temporal table?

882

what is 'mysqlcheck'? : Sql dba

960

how to enter binary numbers in sql statements? : Sql dba

923

What is the reports view in oracle sql developer?

928

What is sqlcontext?

991

When is the update_statistics command used?

1049

Is sql a backend language?

1043

describe mysql connection using mysql binary. : Sql dba

995