select min(sal) from (select sal from emp order by sal desc) where rownu

find the third highest salary?

Question Posted / satish prajapati

Answer Posted / satish prajapati

select min(sal) from (select
sal from emp order by sal
desc) where rownum <= 3

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

993

What is lookup table in sql?

982

Is sql microsoft?

978

What is the use of index in sql?

961

What is the file extension for sql database?

939

What are views in sql?

928

What is the difference between inner join and outer join?

931

what is a cursor? : Sql dba

973

what are the differences among rownum, rank and dense_rank? : Sql dba

985

What is substitution variable?

1003

What is sqlca in powerbuilder?

956

what is a stored procedure? : Sql dba

1054

Explain what is table in a database?

1009

Which is better stored procedure or query?

922

What are database links used for?

994