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
- 33528 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
what is memory-optimized nonclustered indexes
How do you send email on SQL Server?
When do you think a developer should use sql server-based cursors?
What are different types of database indexes?
How do I port a number to sql server?
What are different types of data sources?
How do I get to sql server configuration manager?
What are a database and a data warehouse?
List few advantages of stored procedure.
How to assign new column names in a view?
what are cursors? : Sql server database administration
What do you mean by data integrity?
Why we use trigger in sql server with example?
Explain what is sql server english query?
Define views.
