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

To find second largest salary in Employee table

Question Posted / kuduba.r

Answer Posted / kuduba.r

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are synonyms?

914

What is the difference between lock, block and deadlock? : sql server database administration

992

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

860

What is sharding?

114

How to optimize stored procedures in sql server?

1125

Explain cdc and sql injection?

913

What is the difference between char, varchar and nvarchar?

980

What is difference between oltp and olap?

984

How you can change a cross join into an inner join?

913

Working with TLogs

1786

What are diverse clauses that form a part of sql?

1018

How to execute a sql statement using mssql_query()?

978

What is cross join in sql server joins?

1076

How to delete multiple rows with one delete statement in ms sql server?

943

What is public role in sql server?

1070