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

how to find the second highest salary from emp table?

Question Posted / em rao

Answer Posted / em rao

select max(sal)
from emp
where sal<
(select max(sal)
from emp;)

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What problem one might face while writing log information to a data-base table in pl/sql?

1168

how to get a list of indexes of an existing table? : Sql dba

960

What are instead of triggers?

1046

What is the use of desc in sql?

978

What is sql partition?

1112

What are conditional predicates?

1064

what is 'mysqld'? : Sql dba

973

What are triggers and its types?

1069

What are the steps for performance tuning.

1339

What is the difference between inner join and left join?

990

Explain commit, rollback and savepoint.

1004

Is pl sql useful?

997

What is input buffer in sql*plus?

1230

Which sql most popular?

993

How to place comments in pl/sql?

1161