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
- 32716 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / kumar amit ranjan
To find Top 3 max Sal.... to put any number on the place of
3 to find nth max sal...
select top 3 sal from emp order by sal desc
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to maintain a fill factor in existing indexes?
What is ms sql server reporting services?
When columns are added to existing tables, what do they initially contain?
What is replication with database mirroring? : sql server database administration
What is the difference between dataadapter and datareader?
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Why people hate cursor?
Differentiate between sql temp table vs table variable?
What are the advantages of paper records?
What is the largest component inside a field?
How to modify existing triggers using "alter trigger"?
Can a table be created inside a trigger?
What is server-level principal?
What are system databases into sql server (2005/2008) : sql server database administration
How do I view a stored procedure in sql server?
