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
What is difference between inner join and outer join?
Is a logical database a requirement/must to write an abap/4 query?
8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?
Explain how do you get output from idoc?
What is the significance of the screen number ‘0’?
Can i know some of the Realtime tickets that anyone has been faced ?
Difference between top-of-page and top-of-page during at line- selection?
What do you mean by batch data communications programming?
What are critical issues you have faced in your project
What is meant by hide area?
Advantages and disadvantages of different types of bdc's?
What are pooled tables? : abap data dictionary
How the transaction that are programmed by the user can be protected?
Which infotype records can not be deleted ? : abap hr
Explain the difference between float and packed data type?