select min(sal) from (select distict sal from emp where rownum<3 order

how to find the second highest salary from emp table?

Question Posted / adithya

Answer Posted / adithya

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is rank dense_rank and partition in sql?

1030

How do you truncate?

902

Is foreign key mandatory?

998

Can you upgrade sql express to full sql?

1062

how to load data files into tables with 'mysqlimport'? : Sql dba

1091

Where not exists in sql?

977

Can a varchar be a primary key?

1009

Which normal form is best?

948

what is column? : Sql dba

1002

What is pl sql in oracle?

1039

Is postgresql a server?

1047

How to revise and re-run the last sql command?

1163

Are null values same as that of zero or a blank space?

1026

Is inner join faster than left join?

1190

How do I partition a table in sql?

1126