Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15743 Views
- GeoTechnology, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pankaj kumar
if am not wrong we can also do the same thing by using aggreate function like Min or Max..
Like if i want to know 4th Highest Salary then i can
SELECT MIN(Sal) FROM TableName
WHERE Sal IN
(SELECT TOP 4 Sal FROM TableName ORDER BY Sal DESC)
Regards
Pankaj Kumar
pankaj.arrah@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is polymorphism and advantage ?
What is .net mobile input validation. : Microsoft dot net mobile
Explain about continuable exceptions?
What are end points, contract, address and bindings?
Different types of authentication modes in .net framework ?
What is ILDASM ?
What are the different pipelining hazards? : Dot net architecture
What is Opf3
What do you know about machine.config file ?
What size is a .net object?
Explain about cookie less session state? : .NET Architecture
Explain about .net garbage collector?
Explain the purpose of cache? How is it used? : .NET Architecture
What is the purpose of cache? How is it used? : Dot net architecture
What are the main Tools to develop .Net Application?
