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
- 10378 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 are base tables of an aggregate object? : abap data dictionary
How many default tab strips are there? How to insert more tabs in it?
Value table VS check Table.
What are plan versions used for? : sap abap hr
What are the features of abap/4 dictionary? : abap data dictionary
when does a list get sent to the screen on the presentation layer?
What is difference between inner join and outer join?
What are the commands used for interactive reports?
In a loop of an internal table, what is the use of at first & at last statements?
Define database layer?
Can you assign a matchcode object to a parameter? If so how?
What is the company code? : sap abap hr
How do we handle multiple line items in BDC's.
How are BAPI different from Normal function modules ?
What is synchronous update?
