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 get Top 10 Salaries from a Table

Answer Posted / bharath

select sal from(select ename,sal rownum from emp orderby sal
desc group by sal,rownum)where topsal='&nth';

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2718


What is alias in db2?

1051


How to test SQL -911 error while developing COB-DB2 program

7556


Highlight all the advantages that are attached to a package.

1111


Explain in brief how does db2 determine what lock-size to use?

1034


Explain about rct.

1085


What is commit in db2?

1046


Define declaration generator (dclgen).

1108


What is a cursor in programming?

1062


How to execute stored procedure in db2 command editor?

1047


Before you give the explain statement, what are the prerogatives?

1028


What are db2 objects?

1043


How to create backup table in db2?

1087


List down the data types in the db2 database.

1112


What are the contents of a dclmgen?

1120