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
- 10151 Views
- Enteg Technologies, I also Faced
- E-Mail Answers
Answer Posted / sivaramakrishna
according to our requirment
get allthe records using select * from st_db into stu_itab1.
1.first sort the stu_itab1 by marks field.
now use the select single section from st_db into stu_itab2.
now we have to use select for all entries as below.
select section marks from stu_itab1 into table stu_itab3
for all entries in stu_itab2 upto 10 rows.
it may be not exact . but do try in this way
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different functions used in sap script?
What are table clusters?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
What is meant by authorization? Did you ever work on it? : sap abap hr
What is value table? : abap data dictionary
Explain about interactive report?
Exception handling and how does it transfer from called method to calling method?
what is the t-code to link technical and functional operation?
What are function modules?
What is search help exit? : sap abap data dictionary
What is value table?
What are the Various Types of internal tables?
What is the function module to popup contents in the internal table?
What is read line in abap?
In sap script how to print bar code in vertical manner
