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

A database table contains 3
fields(Student_no,Section,Total_marks).I want retrieve top 10
students from each section.Note:(Section contains data like
A,B,C.Each section contains more than 10 students).

Answer Posted / balamurugan

REPORT zscenario.
DATA itab LIKE zabc OCCURS 10 WITH HEADER LINE.
SELECT * FROM zbad5 INTO TABLE itab.
SORT itab BY sclass smarks.
LOOP AT itab.

AT NEW sclass.

WRITE: / itab."-sno1 itab-sclass itab-smarks.

ENDAT.
This display the report based upon the class.But i don't know how to retrieve 10 records from each class.

ENDLOOP.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to find Kernal badi ?

1551


what is the process of creating quotation using BAPIs.

1990


What are the restrictions on subscreens?

1190


What is macro? : abap hr

1049


How can we access the correction and transport system?

971


What are screen painter and menu painter? : abap hr

983


What is sap locking?

992


In a loop of an internal table, what is the use of at first & at last statements?

1914


What is the difference between a structure and a table?

1044


Exception handling and how does it transfer from called method to calling method?

1435


What is the disadvantage of using exec sql statement in abap?

1021


Difference between /N and /BEND?

1200


What are the major steps will you use for tuning?

1006


Is it possible to run host command from SAP environment? How do you run?

1055


What are the function modules used to create batch input session? : abap bdc

1096