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
- 31713 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
Which tools are available to manage SQL Azure databases and servers?
how to overcome kernel isssues
What are xml indexes?
What are the different types of stored procedures?
Explain in details security in SQL azure?
Can you please explain the difference between function and stored procedure?
How to name query output columns in ms sql server?
How to use clusters?
What is the latest version of microsoft sql server?
What is difference between cte and view?
How are the exceptions handled in sql server programming?
Does partitioning ssd reduce performance?
How many types of objects are there?
What is full outer join in sql server joins?
What is difference between count (*) and count 1?
