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 are the differences between ms sql server & oracle?

1070

explain different types of joins? : Sql server database administration

994

Explain what is use of dbcc commands?

1065

What is molap and its advantage? : sql server analysis services, ssas

1000

How to update a field in SQL after ALTERING a row?

1241

What is save transaction and save point?

1213

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1172

What are the export options of ssrs?

174

What is dbcc?

1147

what is an index? : Sql server database administration

991

What is dirty page?

979

How do I port a number to sql server?

1048

Does the order of columns in update statements matter?

919

What is nonclustered index on computed columns?

966

Explain external key management in sql server 2008

895