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

How do you delete duplicate rows in sql server?

1007

How to how to convert numeric expression data types using the convert() function??

1096

Can we join two tables without primary key?

1095

How to execute stored procedure in select statement sql server?

1114

Can We Use Data-grids For Our Report In Ssrs?

188

Explain what are the authentication modes in sql server?

1073

Which are the new data types introduced in sql server 2008?

931

What is statement level trigger?

1048

What is a trigger? Why we need it?

1058

What are the different sql server versions?

1034

Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security

1132

Can you leave a union at any time?

1109

What is transaction server consistency?

1106

how to trace the traffic hitting a sql server? : Sql server database administration

1956

Do you know what is blocking?

996