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
- 33597 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
What is a bit datatype?
Why I am getting this error when renaming a database in ms sql server?
Write a sql query to get zero records from a table having n number of records?
What's new in sql management studio for sql server? : sql server management studio
How do you delete a data source?
What is the importance of concurrency control?
Can coalesce return null?
How to fetch the next row from a cursor with a "fetch" statement?
Where sql server usernames and passwords are stored in a sql server?
Why use update_statistics command in sql server?
Please explain go command in sql server?
New concepts of sql server 2005 use in your project.
Define synonym?
What are the differences between stored procedure and the dynamic sql?
What is key attribute?
