how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
- 11 Answers
- 12500 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / arrry.net
Select top 1 salary from tbl_registration where salary in
(SELECT TOP 2 salary from tbl_registration)
order by salary desc
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you explain scriptmanager control?
Explain the race around condition? How can it be overcome? : Dot net architecture
What are the main Tools to develop .Net Application?
Explain difference between machine config vs. Web config? : .NET Architecture
Define cache? : Dot net architecture
How can I write my own .NET host?
Describe the advantages of writing a managed code application instead of unmanaged one. What is involved in certain piece of code being managed?
What's the difference between an application and a program?
What are the types of memory management? : Dot net architecture
What do you know about machine.config file ?
question related to table havi colspan and row span
difference between data reader and dataset
Explain some of the disadvantages due to microsoft.net?
How do we do authentications using atlas?
What is the cli? Is it the same as the clr?
