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 query optimization in sql?

1040

What are synonyms in sql?

1018

how to escape special characters in sql statements? : Sql dba

1080

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2268

how to show all tables with 'mysql'? : Sql dba

1156

what is the difference between cluster and non cluster index? : Sql dba

1075

How much does a sql dba make? : SQL DBA

986

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1223

What is write ahead logging in sql server?

1097

What is a constraint?

1082

What is pl sql script?

1081

What is data type in database?

1039

what is 'mysqldump'? : Sql dba

1165

how many triggers are allowed in mysql table? : Sql dba

1102

Explain foreign key in sql?

1079