how to find the 2nd higgest salary in the column for example
take table name is employee?
And also find bottom 2nd lowest salary ?
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
How do I know when my thread pool work item has completed?
What are the different pipelining hazards and how are they eliminated? : Dot net architecture
What size is a .net object?
Explain .net mobile automatic paging? : Microsoft dot net mobile
What is an interrupt? : Dot net architecture
What is parallel computing?
How to prevent my .NET DLL to be decompiled?
Explain 'managed' mean in the .NET context
What is .net mobile forms? : Microsoft dot net mobile
difference between Response.write,server.transfer and also which one is used when ?
Waht is Dot net Arcitecture
How do you handle this COM components developed in other programming languages in .NET?
How can we integrate atlas with web services?
what are constructors and destructors?
Explain how cache is used? : Dot net architecture