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
- 10083 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 pooled and cluster tables?
What is netweaver???what is the relationship with ABAP?
What are the Control levels in internal tables?
Describe data classes? : abap hr
What are the different methods of passing data?
How to transfer data into line items using batch input session method? : abap bdc
What is primary index?
How to Modify Layout set for RVORDER01 for printing sales order confirmation. plz mention the detail coding Tahnks, Rahul
What are the client dependant objects in abap / sap?
8)when u create sales report what u can see in that report ? what rthose field names or data element names? 9)when u create purchase order details report what u can see in that report ?what rthose fieldnames or dataelements? 10)when u create material stock report in material master grouped by material type and plant what u can see in report ?what rthose field names or dataelement ? 11)when u create shipping forecast report what u can see in that report ?what rthose data elements or field names?
What are the different functions used in sap script? What are the parameters used in each function?
What is lock mechanism? How do we create lock objects in abap?
How do you execute the payroll
Can you delete data element, which is being used by table fields?
Explain the inside concept in select-options?
