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
- 10084 Views
- Enteg Technologies, I also Faced
- E-Mail Answers
Answer Posted / waseem
**Sorry guys for above wrong code which I posted, You can **use this code with 100 % result****
tables : ywt_student, ywt_result.
data : begin OF itab OCCURS 0, "structure from 2 tables
usn like ywt_student-usn,
name like ywt_student-name,
dob like ywt_student-dob,
cls like ywt_result-class,
marks like ywt_result-marks,
end of itab.
**"selecing values from 2 tables*****
select ywt_student~usn name dob class marks
INTO TABLE itab
from ywt_student INNER JOIN ywt_result on ywt_student~usn = ywt_result~usn.
**Sorting for testing Perpose*****
sort itab by cls ASCENDING marks DESCENDING.
LOOP AT itab.
on CHANGE OF itab-cls.
skip.
ENDon.
WRITE :/ itab-usn, itab-name, itab-dob, itab-cls, itab-marks.
ENDLOOP.
skip 2.
***Actual Logic of Requirement***
data : m LIKE ywt_result-marks.
data : count TYPE i value 0.
CLEAR itab.
sort itab by cls ASCENDING marks DESCENDING.
CLEAR itab.
LOOP AT itab.
m = itab-marks.
on CHANGE OF itab-cls.
skip 2.
count = 0.
ENDon.
AT NEW cls.
itab-marks = m.
count = count + 1.
IF count LE 10.
WRITE :/ itab-usn, itab-name, itab-dob, itab-cls, itab-marks.
CLEAR itab.
ENDIF.
ENDAT.
ENDLOOP.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is an interactive report? What is the obvious difference of such report compared with classical type reports?
How can you find the field/data underlying a transaction?
How to combine multiple order in one Delivery ( Step by Step)?
Can we specify the next screen number with a variable?
How to read files and process BDC's automatically ?
Difference between call by value and call by reference? : abap data dictionary
What is a match code? : abap data dictionary
What is the process to enhance the Infotype
What is the meaning of abap editor integrated with abap data dictionary? : abap data dictionary
How do you read files from the application server ? : abap bdc
Define spool request?
What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1
Explain the uses of the simple maintenance interface? : sap abap hr
What happens if only one of the commands set screen and leave screen is used without using the other?
How will you find manager of an employee
