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
- 33555 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / dhaval
we have to use distinct key word there is a possibility
that two person having same salary.
select top 1 sry from (select distinct top 2 sry from emp
order by sry desc)t1 order by sry asc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do you create a clustered index?
1 01 101 01010
What are the different editions available in sql server 2000?
Describe different Processing Modes offered by SSRS?
How do you run a trace?
What is compound operators?
What is tablix?
Where do you find the default Index fill factor and how to change it?
How to resolve the orphan use problem? : sql server security
What the class forname () does?
Can a table have 2 primary keys?
How to copy data from one table to another table?
What are subqueries in sql server?
Can we use max in where clause?
What are the differences between stored procedure and the dynamic sql?
