can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com
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
Does partitioning improve performance sql server?
If a table does not have a unique index, can a cursor be opened on it?
What is isolation levels?
What is sleeping status in sql server?
What type of Index will get created after executing the above statement?
How to create new tables with "create table" statements in ms sql server?
What is difference between rownum and rowid?
what are the new features in SSRS?
Call by value and call by reference in procedure and function, with NOCOPY.
Is it possible to call a stored procedure within a stored procedure?
List all types of constraints in sql server?
Difference between primary key and clustered index?
Explain optimistic and pessimistic concurrency?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is a heap?