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 / gaurav walia

first sort the rank field by descending.....den select rank up to 3 rows...

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to bring select option in module pool screens?

974


Which transaction code is used executing a report (type 1 program)? : abap data dictionary

1046


Differentiate screen painter from menu painter.

1054


What are base tables of an aggregate object?

1115


Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.

2074


What is a multiple line field?

1046


Select query optimisation

1372


Explain different types of attributes of function module?

960


How many lists can a program can produce?

1063


When value table becomes check table?

1072


What are the different types of parameters?

1165


What is sql trace? : abap data dictionary

1187


What is the purpose of sum statement?

988


What is an “on input filed” statements?

1166


How we can give authorization on the fields of table control in a dialog-programming?

2313