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 / venkat

select max(sal) from tablename.

Is This Answer Correct ?    7 Yes 51 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is ibm db2 free?

952


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029


What is the use of with ur in db2?

996


Can we insert update delete in view?

908


Highlight all the advantages that are attached to a package.

1071


How to rename a table in DB2 ?

1029


Mention the downsides of page level lock.

1112


Comment whether the cursor is closed during commit or not.

1039


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1102


What is the use of reorg in db2?

1023


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2311


What are db2 objects?

999


What is db2 bind process?

1178


How to find primary key of a table in db2?

1001


Can we update view in db2?

944