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
- 32371 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / dileep.t
If you need the second highest salary only
then following will also work,
select Max(Salary) from TableName
where Salary not in(
Select Max(Salary) from TableName)
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
How can windows applications connect to sql servers via odbc?
what is a correlated sub-query? : Sql server database administration
How do you improve the performance of a SQL Azure Database?
How to connect to a sql server using odbc_connect()?
Do you know what is xpath?
how you can deploy an ssrs report?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Would you store your query in a ssrs report or a database server? State the reason why?
What is updatable resultset?
How do I setup a local sql server database?
how to overcome kernel isssues
What is the importance of concurrency control?
How to rename databases in ms sql server?
Can you explain what are commit and rollback in sql?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
