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

Why coalesce is used in sql?

1067

how can we submit a form without a submit button? : Sql dba

1036

what is an index? : Sql dba

1039

What is a trigger in sql?

1234

What is the difference between a primary key and a clustered index?

1035

what is 'trigger' in sql? : Sql dba

1145

Explain spool.

1219

What is gpt format?

991

Can function return multiple values in sql?

1098

What are local and global Indexes and where they are useful.

1494

What are the ways on commenting in a pl/sql code?

1204

What is the difference between left outer join and left join?

1037

How to write pl sql program in mysql command prompt?

1165

What plvcmt and plvrb does in pl/sql?

1366

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1104