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

Can you upgrade sql express to full sql?

1062

Is drop table faster than truncate?

985

how to run 'mysql' commands from a batch file? : Sql dba

1114

Is primary key clustered or nonclustered?

1012

What is the difference between a database and a relational database?

1099

Can we use join in subquery?

1093

How do I view output in sql developer?

1082

What is substitution variable?

1050

Which join is like inner join?

1025

How do you define a foreign key?

996

what is a constraint? Tell me about its various levels. : Sql dba

985

Is sql a microsoft product?

949

Explain what is a column in a table?

1105

How do I count rows in sql?

999

What is data control language?

985