SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT MAX(SALARY)

To find second largest salary in Employee table

Question Posted / saravanakumar

Answer Posted / saravanakumar

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN
(SELECT MAX(SALARY) FROM EMPLOYEE)

Is This Answer Correct ?

13 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to count duplicated values in a column in ms sql server?

1099

Write the syntax for stuff function in an sql server?

1032

can an order by clause be used in a creation of a view?

1185

What is sub-query in sql server? Explain its properties.

1098

How to enable/disable indexes?

1070

What is clustered primary key?

1033

What is sqlcmd?

1062

What is transaction server consistency?

1054

Explain syntax for dropping triggers?

935

How you would rewrite the sql query to return the customerid sorted numerically?

1004

What are the advantages of using cte?

1023

What is report rendering ?

162

What is the maximum size of a dimension? : sql server analysis services, ssas

1050

What are the new data types are introduced in sql 2000?

908

What is subquery in sql?

1074