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

How can a pl sql block be executed?

948

Define commit, rollback and savepoint?

1032

Which certification is best for sql?

990

Why are cursors used?

1122

What is the difference between jpql and sql?

1096

What is a string data type in sql?

1045

What are different methods to trace the pl/sql code?

1120

What is dml and ddl?

959

what are aggregate and scalar functions? : Sql dba

1057

What are the types of queries in sql?

1086

Is delete faster than truncate?

1002

Can we insert data into view?

904

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

Define concurrency control. : Transact sql

1192

How does cross join work in sql?

1018