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
- 15355 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
How to improve the cache performance? : .NET Architecture
Explain difference between inprocess vs out process session state? : .NET Architecture
i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?
inprocess vs out process session state : Dot net architecture
what are constructors and destructors?
Explain difference between machine config vs. Web config? : .NET Architecture
What is MS chart control in visual studio?
How to develop mobile applications using microsoft mobile internet toolkit (mmit) or .net mobile? : Microsoft dot net mobile
Explain cache memory? : Dot net architecture
How to prevent my .NET DLL to be decompiled?
I can't be bothered with cas. Can I turn it off?
Explain .net mobile events? : Microsoft dot net mobile
What is cache coherency and how is it eliminated? : Dot net architecture
Different types of authentication modes in .net framework ?
Explain .net mobile automatic paging? : Microsoft dot net mobile
