Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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


Please Help Members By Posting Answers For Below Questions

How do I know when my thread pool work item has completed?

924


What are the different pipelining hazards and how are they eliminated? : Dot net architecture

1034


What size is a .net object?

1041


Explain .net mobile automatic paging? : Microsoft dot net mobile

935


What is an interrupt? : Dot net architecture

961


What is parallel computing?

960


How to prevent my .NET DLL to be decompiled?

1056


Explain 'managed' mean in the .NET context

1133


What is .net mobile forms? : Microsoft dot net mobile

930


difference between Response.write,server.transfer and also which one is used when ?

1930


Waht is Dot net Arcitecture

2408


How do you handle this COM components developed in other programming languages in .NET?

1050


How can we integrate atlas with web services?

954


what are constructors and destructors?

2157


Explain how cache is used? : Dot net architecture

1081