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

Explain alternate key, candidate key and composite key in sql server?

916

What is the function of inner join?

1074

Does a full backup include transaction log?

976

Differentiate between mongodb vs. Sql server?

1101

List the ways in which dynamic sql can be executed?

1015

Can sql servers linked to other servers?

1046

what's the information that can be stored inside a bit column? : Sql server database administration

1035

How adventureworkslt tables are related?

930

how you can list all the tables in a database?

1026

What does top operator do?

1021

Explain multiserver query

1046

Name few of the dcl commands in sql?

1007

What is dbcc command in sql server?

1093

What is the purpose of indexing?

1046

What is dbcc updateusage?

1205