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

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / m

Answer Posted / m

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

Is This Answer Correct ?

222 Yes

39 No

Please Help Members By Posting Answers For Below Questions

What is sql deadlock?

1126

Is sql a backend?

1008

What is varchar data type in sql?

1075

What are the features of pl sql?

1059

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

1019

Which is the correct statement about truncate and delete?

1103

What makes a good primary key?

1028

Can a commit statement be executed as part of a trigger?

1045

what are enums used for in mysql? : Sql dba

1164

What's the procedure?

920

Do prepared statements prevent sql injection?

946

Does sql*plus have a pl/sql engine?

1064

what are the drivers in mysql? : Sql dba

1012

What is mdb stand for?

1003

What is pivot in sql?

906