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 are the parameter modes supported by pl/sql?

1019

What are the types of queries in sql?

1015

what are the type of locks ? : Sql dba

898

What is the use of & in pl sql?

985

Can we rollback delete command?

934

What is left join in postgresql?

995

what is data manipulation language? : Sql dba

946

how to see the create table statement of an existing table? : Sql dba

946

Define sql delete statement.

953

Can a table have no primary key?

1009

What is pl sql code?

992

What is sql comments?

1031

What is partition by in sql?

1001

Is sql a microsoft product?

896

What is the basic form of sql query?

880