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 nth highest salary

Answer Posted / deepak dabi

I Think this is the best solution ever i have seen ,i
appriciate if you prove me wroong on this so,otherwise i got
all other a bit wrong ,in many cases please try this....



"SELECT distinct(sal) from emp order by sal desc limit 2,1"

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me in brief how sql server enhances scalability of the database system?

995


How to enter comments in transact-sql statements?

951


Explain four layers of abstraction microsoft architectured?

147


Define msdb database?

1043


What do you understand by a view?

1007


What is postgresql server?

1012


How can we delete Duplicate row in table?

1075


What are .mdf files?

951


What is an expression in ms sql server?

1085


What is mscorsvw.exe - process - microsoft .net framework ngen?

961


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

193


How to disable a login name in ms sql server?

1140


What are the options which must be set to allow the usage of optimistic models?

965


Is sql server difficult to learn?

928


Can we use max in where clause?

939