select top 1 * from emp where sal not in (select max(sal) from emp) order

how to find the second highest salary from emp table?

Question Posted / sunil

Answer Posted / sunil

select top 1 * from emp where sal not in (select max(sal)
from emp) order by sal desc

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can we debug in PL/SQL?

1089

The select into statement is most often used to create backup copies of tables or for archiving records?

1000

What is sql query limit?

907

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2107

What is sql engine in oracle?

925

Can we alter stored procedure?

940

What is normalization in sql?

961

Which table is left in join?

913

Is sql a microsoft product?

895

what is the use of double ampersand (&&) in sql queries?

1114

What is over () in sql?

891

How do you use a while loop in pl sql?

939

What is trigger point?

948

What is audit logout in sql profiler?

976

How to look at the current sql*plus system settings?

1077