can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
- 28 Answers
- 25066 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sandeep rana
Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
difference between Clustered index and non clustered index ?
How to receive output values from stored procedures?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain about service Broker functions?
What is tempdb database? : SQL Server Architecture
What are the export options of ssrs?
is there a column to which a default can't be bound? : Sql server database administration
What is application role in sql server database security? : sql server security
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is report server project?
Where are stored procedures in sql server?
How do I find my localdb version?
List out the different types of locks available in sql server?
How to get @@error and @@rowcount at the same time?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
