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 are different types of subquery?

1184

What is join query?

841

How to use values from other tables in update statements in ms sql server?

1041

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

973

How do you rename a table in sql server?

944

How to make a remote connection in a database?

927

What are the built in functions in sql server?

919

How to rebuild indexes with alter index ... Rebuild?

1035

Why do we need normalization?

878

Explain different types of self contained sub query?

953

How many partitions a clustered index has by default in sql server 2012?

1053

Explain in brief about Microsoft SQL server?

1014

Can coalesce return null?

948

Describe and explain about SQL native client?

1041

Relational calculus is what type of language?

978