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 can we find nth max salary from A table

Answer Posted / asp

select * from table1 a where (n-1) = (select count(distinct
(sal)) from table1 b where b.sal>a.sal)

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of db2 optimizer?

1356


How is deadlock resolved?

1202


How do I delete a column in db2?

1154


How to find schema of a table in db2?

1066


What is the latest version of ibm db2?

1335


How to connect to db2 database from windows command line?

1136


Mention the definition of cobol in varchar field.

1315


What is the default page size of buffer pools?

1170


What is cobol db2?

1046


What is the function of logging in the db2 database?

1172


Define check constraint.

1128


What are the contents of dclgen?

1160


How do I start db2 in windows?

1139


What is the difference between bind and rebind in db2?

1511


Define declaration generator (dclgen).

1172