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

Can you load data into multiple tables at once? : aql loader

1074

Does varchar need length?

1000

How can we link a sql database to an existing android app?

1036

how many sql dml commands are supported by 'mysql'? : Sql dba

1128

what are enums used for in mysql? : Sql dba

1173

Why do we use view in sql?

970

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

In a distributed database system, can we execute two queries simultaneously?

1098

what are integrity rules?

1036

Is stored procedure faster than query?

971

Explain the difference between triggers and constraints?

981

How do I remove all records from a table?

1081

What is pl sql quora?

1176

What is union and union all keyword in sql and what are their differences?

1108

What is string join?

981