SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY) FROM EMP)

To find second largest salary in Employee table

Question Posted / anjum

Answer Posted / anjum

SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to delete existing triggers using "drop trigger"?

1103

what are the different stages of Report Processing?

141

What are the tables in sql?

1152

Describe in brief system database.

1075

Explain the creation and execution of a user-defined function in the sql server?

1113

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1056

Explain what is use of dbcc commands?

1136

Find nth lowest salary or get nth lowest salary?

1084

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1267

Explain few of the new features of sql server 2008 management studio

980

What is clustered primary key?

1084

What is a view and what are its advantages?

1170

What are the difference between primary key and unique key? : sql server database administration

992

What happens if the update subquery returns multiple rows in ms sql server?

1171

Define Wed Edition in SQL Azure?

102