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
How to find Kernal badi ?
what is the process of creating quotation using BAPIs.
What are the restrictions on subscreens?
What is macro? : abap hr
How can we access the correction and transport system?
What are screen painter and menu painter? : abap hr
What is sap locking?
In a loop of an internal table, what is the use of at first & at last statements?
What is the difference between a structure and a table?
Exception handling and how does it transfer from called method to calling method?
What is the disadvantage of using exec sql statement in abap?
Difference between /N and /BEND?
What are the major steps will you use for tuning?
Is it possible to run host command from SAP environment? How do you run?
What are the function modules used to create batch input session? : abap bdc