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).
- 7 Answers
- 10282 Views
- Enteg Technologies, I also Faced
- E-Mail Answers
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 check table and value table ?
What are the different modules of sap? : sap abap hr
What are authorization objects and what statement is used to perform an authorization check in an abap program?
In the MM module for finding out the standard cost what is the view one has to look at?
Can we include customizing include or an append structure with pooled or cluster tables?
What is pass by value and what is pass by reference? Which is better?
when do you need to create an internal table with header line ? and with out a header line?
What are the steps to execute session method?
How can an internal table with header line and one without header line be distinguished when passed to a subroutine? : abap modularization
What is a help view? : abap data dictionary
What are the domains and data element?
what is difference between user exit, customer exit and badi?
What is the function of a data element? : abap data dictionary
Explain what is the difference between sy-tabix and sy-index? Where it is used?
What is the collect statement?
