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...

There is a Database Table of Student Details with Fields Student Id, Student Name, Class ID and Rank. Now how to fetch the first three students with highest ranks from all Classes.

Answer Posted / vinay

in the select statement use the max keyword and select up to
3 rows .

Is This Answer Correct ?    2 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 3 tire architecture and how does SAP utilizes this architecture. and how do netweaver came into picture?

2253


Why bapi need then bdc ? : abap bdc

1105


Work most on which module: name a few tables?

1053


Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc

1157


What are the dis-advantages of logical databases? : abap hr

1143


Where the payroll results are stored

2370


What are the functional areas? User groups? and how does ABAP query work in relation to these?

1154


How do you read files from the application server ? : abap bdc

1114


How to call a subroutine in sapscript?

1119


Define subtype ? : abap hr

1025


When value table becomes check table?

1072


What are the differences between a database index and a match code?

1163


What is a bsp application? : sap abap hr

1131


Explain the Types of Select statements?

1074


what is user specific parameter?

2058