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

how to calcuate the second highest salary of he employee

Question Posted / shailesh

Answer Posted / shailesh

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between mdf and ndf files?

1168

What are the parameter modes supported by pl/sql?

1162

Which are the different character-manipulation functions in sql?

1123

How sql query is executed?

1189

How can I speed up sql query?

1017

Is it possible to pass parameters to triggers?

1169

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

1260

How do you update a value in sql?

1105

what is a composite key ? : Sql dba

1103

What are field types?

1057

what are the properties and different types of sub-queries? : Sql dba

1088

What is data definition language?

1139

Can a varchar be a primary key?

1059

What is sql deadlock?

1227

How to return an array from java to pl/sql?

1190