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
- 32389 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
How to create a view with data from multiple tables?
What do you mean by sql server agent?
Create and insert into temp table in sql server?
What are Row versions of DataRow?
How and why use sql server?
What are the commands used in DCL?
Does a full backup include transaction log?
What is a coalesce function?
What is query parameter in ssrs?
What is page-level compression?
where can you add custom error messages to sql server? : Sql server administration
What is model database in sql server?
Why de-normalization required?
How to use the inserted and deleted pseudo tables?
How to modify an existing stored procedure in ms sql server?
