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

What is textview control of .net mobile? : Microsoft dot net mobile

947


how to change row background color in gridview

942


how to delete the record using data reader

2413


What is IL code, CLR, CTS, GAC & GC?

974


I am working with asp.net 2005 and Crystal report 10. I have an image field on my dataset to show on Crystal report.And the image is shows dynamically from database in image field of CR. The image field is showing well on my Crystal report on its first page with all other data but when i click to open second page of CR,it does not show any data on that.I found that this is because of adding the image field on crystal report. Because when i remove the image field from the CR then it will run both the pages of CR. I am using the Page Load event to bind CR data with Database. And i have already check with the Init event to bind CR , but it still not shows the data on second page when i use image field on that. Please give solution for that.....

1827


What is .net mobile input validation. : Microsoft dot net mobile

885


Can you Explain element .net mobile with example? : Microsoft dot net mobile

891


Tell me .net mobile emulators? : Microsoft dot net mobile

898


Can you explain server controls in atlas?

927


What are the options provived by vss to the user? how it will help us while delevoping application?

2158


Can you explain scriptmanager control?

961


i wish to write mcts(microsoft certified technology specialist) exam. can anyone give the model question or format and preparation method?

2707


HttpHendler and HttpModules

2109


How cache coherency is eliminated? : Dot net architecture

861


IS IT Possible to inherit the AJAX page from child class which(child) is inherit from page class.Because i should apply some security in child class

1969