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
- 10296 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 are the events in screen programming?
How many ways can a sap system be accessed?
What does an exec sql statement do in abap? What is the disadvantage of using it?
What are the rules to create a BAPI?
Differentiate between static and dynamic step loops?
What is a match code? : abap data dictionary
What is the difference between the function module and a normal abap/4 subroutine?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
What are the advantages and disadvantages of using views in abap programming ?
Can we display a list in a pop-up screen other than full-size stacked list?
When, how and how would you control changes to standard SAP objects.
What is the difference of update types in call transaction method ? : abap bdc
What is the differences between structure and table in data dictionary in abap?
What are the steps in creating screen ?
Explain the different types of data dictionary objects?
