SELECT MAX(EMP_SALARY) FROM EMP WHERE EMP_SALARY NOT IN (SELECT MAX(EMP

How to read 2nd highest sal from EMP table?

Question Posted / sheshu4040

Answer Posted / sheshu4040

SELECT MAX(EMP_SALARY) FROM EMP
WHERE EMP_SALARY NOT IN (SELECT MAX(EMP_SALARY) FROM EMP)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is buffer cash in sql server?

1206

What does null mean?

1053

What is difference in performance between insert top (n) into table and using top with insert?

1122

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1088

What function does a database engine serve in the sql server?

1081

What are the two modes of authentication in sql server?

1137

What command do we use to rename a db, a table and a column?

981

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

930

How can a database be repaired?

1034

What is SQL Azure?

107

How to use subqueries with the in operators in ms sql server?

1125

What is user-defined multi-statement table-valued function?

1120

Can you move the resources after pausing the node? : sql server database administration

1168

How to set database to be single_user in ms sql server?

1082

What is a primary key?

999