select min(sal) from (select sal from (select sal from emp order by sal

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / neha singh

Answer Posted / neha singh

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference sql and mysql?

535

What is an inconsistent dependency?

583

How does cross join work in sql?

535

What is keys and its types?

548

How do I create a sql database?

526

How insert into statements in sql?

595

how many groups of data types? : Sql dba

569

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

540

What is the use of index in hive?

552

What does select count (*) mean in sql?

556

Why trigger is used in sql?

537

Explain what is a database?

652

Why is the cursor important?

543

describe mysql connection using mysql binary. : Sql dba

555

How do I restart sql?

528