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 a scheduled job or what is a scheduled task?

941

When I delete any data from a table, does the sql server reduce the size of that table?

991

Explain the types of indexes.

1178

Name few of the dcl commands in sql?

989

What is a trigger what are the advantages of trigger?

973

What is ms sql server triggers?

990

What is the primary use of the model database?

1064

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

963

Do you know what are the differences between lost updates and uncommitted dependencies?

1052

What is difference between index seek vs. Index scan?

1130

What is for xml in sql server?

1039

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

856

How to insert a new row into a table with "insert into" statements in ms sql server?

949

What are the rendering extensions of ssrs?

153

What is index in an assignment?

933