select min(sal) from emp where sal in (select top 2 sal from emp order by

find out the second highest salary?

Question Posted / sumeet

Answer Posted / sumeet

select min(sal) from emp where sal in (select top 2 sal from
emp order by sal desc);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the usage of analyze command in oracle?

1034

What happens if variable names collide with table/column names?

1108

How to create a single index for multiple columns?

981

How to convert raw data type into text in oracle? Explain

953

Explain alias?

1082

How to assign values to data fields in record variables?

977

What is merge statement used for?

974

Define oracle database

993

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4475

What are the types of trigger in oracle?

917

what is normalisation?what are its uses?

2213

please explain.. DB architecture ...

1971

What are the different pseudo commands? Explain in general?

1022

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1061

What is the recommended interval at which to run statspack snapshots, and why?

2863