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 is sqlca?

1084


Define data page.

1075


Which isolation level provides highest data integrity?

1128


What is alias in db2?

1068


How is the value function used?

1158


What is the difference between using bind () and rebind () methods of naming class?

1406


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2072


What is a page in db2?

1030


What is ibm db2 connect?

1005


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1082


What is copy pending status in db2?

1128


What is runstats and reorg in db2?

1309


What is runstats db2?

1042


How does a cursor work?

994


List some fields from sqlca?

1062