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 cached report?

150

Please explain what is “asynchronous” communication in sql server service broker?

982

How to find out the list schema name and table name for the database?

984

What is the stuff and how does it differ from the replace function?

1227

Is ssrs support other database except ms sql server?

142

What is a bit datatype?

1022

How can we use ConnectorJ JDBC Driver with MS SQL?

1053

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

1011

What happens if strings are casted into wrong code pages in ms sql server?

1167

What is the difference between DATETIME2 and DATETIME?

1131

Explain partitioned view?

1133

How do you check sql server is up and running?

1055

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

938

What’s the distinction between dropping a info and taking a info offline?

1093

What does normalization do to data?

1142