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
Name some system global variables you can use in abap programs?
What are the data types of the abap/4 layer? : abap data dictionary
What are the different function modules used in sapscript?
Which transaction code can I use to analyze the performance of abap program?
Why do we use dynamic where conditions?
Explain difference between primary key and unique key?
How many lists can a program can produce?
What happens Update command is used without where clause ?
can anybody give me functional specification (or table name & field names) of stock analysis report, work in progress report,generating vendor detailed list
What are the different types of view?
What is sequence number
What is a help view? : abap data dictionary
Explain the differences between sap memory and abap memory?
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
What is a table attribute?