SELECT ID,MAX(SALARY) FROM EMP WHERE SALARY

I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000

Question Posted / sivanandam

Answer Posted / sivanandam

SELECT ID,MAX(SALARY) FROM EMP
WHERE SALARY < SELECT MAX(SALARY) FROM EMP

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is difference between drop truncate and delete?

1068

What do you mean by an execution plan? Why is it used?

993

How do you run a trace?

887

When would you use a before or after trigger?

892

tell me the disaster recovery plan

2499

How many types of subqueries are there in sql server?

972

can we have a nested transaction? : Sql server database administration

1054

Can sql servers linked to other servers like oracle?

929

How much space does sql server 2016 take?

939

What is the function of inner join?

1046

Is it possible to update the views? If yes, how, if not, why?

1007

What is sub query and its properties?

964

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1113

What stored by the master? : sql server database administration

1086

How to create a local temporary stored procedure?

984