select max(sal) from emp where empsal<(selelect max(sal) from emp)

how to find the second highest salary from emp table?

Question Posted / teja

Answer Posted / teja

select max(sal) from emp where empsal<(selelect max(sal)
from emp)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a record in pl/sql?

1069

What is cursor status?

1135

Explain the working of primary key?

1033

How to read/write files from pl/sql?

991

Does truncate free space?

945

What is rownum?

923

What is schema in sql example?

1087

What is a join query?

905

What is the purpose of using pl/sql?

1075

What are tables and fields?

973

What are sql commands?

934

What is nosql db?

923

What are few of the schema objects that are created using PL/SQL?

967

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

946

What is meaning of <> in sql?

1019