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
- 32695 Views
- IBM, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sandeep rana
Select top 1 salary from table where salary in(select top 2
salary from table order by salary desc)order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write the syntax for stuff function in an sql server?
How to create a scrollable cursor with the scroll option?
What is merge join?
What are the rendering extensions of ssrs?
What are the advantages of mirroring?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
what are different types of raid configurations? : Sql server database administration
Explain what are sparse columns?
What are partitioned views and distributed partitioned views?
How to create a store procedure with encryption?
Is it possible to create trigger on views?
What is DCL?
What is store procedure? How do they work?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is the difference between delete and truncate statements?
