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

Explain the usage of floor function in sql server.

913

Explain indexing and what are the advantages of it?

959

What is the purpose of update statistics and scope_identity() function?

1046

How to get the definition of a stored procedure back?

918

what does the automatic recovery do? : Sql server administration

958

How do you improve the performance of a SQL Azure Database?

135

How to execute a sql statement using odbc_exec()?

1056

What is ddl command?

924

what is raid and what are different types of raid configurations? : Sql server database administration

974

What is sql server database?

935

What is exclusive locks?

915

Why do we use functions?

852

Explain the benefits of user-defined functions?

986

in the physical file layout, where should the transaction log be stored in relation to the data file?

939

What are the advantages of passing name-value pairs as parameters?

1102