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
- 10375 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
How would you define the exponents for a type âfâ field?
What are the dynapro keywords?
What are system variable in abap?
What is a transaction variant and why are they used?
How can we use / display table in a screen?
What are authorization objects and what statement is used to perform an authorization check in an abap program?
What are conversion routines? : abap data dictionary
How do you find if a logical database exists for your program requrements?
What are the pooled and cluster tables?
while implementing badi what are the tables u find??
What is the different type of projects? : sap abap hr
Concepts of OO ABAP and why we are using it?
Can we write the code both call transaction and session method in single program?
What are the list of screen elements?
What are the disadvantages of logical databases?
