Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 31721 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / kumar
1 My Second Answer.
Select Top 1 * From Tablename where salary in
(select top 2 salary from tablename order by salary desc)
order by salary asc.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Do you know nested transaction?
In which format does an image save in SQL Server database ?
How can we use ConnectorJ JDBC Driver with MS SQL?
How much space does sql server 2016 take?
what types of replication are supported in sql server? : Sql server database administration
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
Explain hostprotectionattribute in sql server 2005?
Can you always create a cache of a report?
Describe how to use linked server?
Tell me what is a linked server?
Explain different types of locks in sql server.
what information is maintained within the msdb database? : Sql server administration
Define cross join in sql server joins?
How many databases can we create in a single server?
What is updatable resultset?
