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).

Answer Posted / sateesh

for this initially we can SORT in assending order,
then using "select up to 10 rows".

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between sum and collect?

894


What are pooled tables? : abap data dictionary

667


Example of table cluster and cluster tables.

653


How to combine multiple billing into one RV document ( Step by Step)?

1543


What is the modification assistant?

582






Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

602


How the at-user command serves mainly in lists?

620


Explain the advantages and disadvantages of different types of bdc's?

610


What are secondary indexes. How can we know which index is being used in a select query?

1004


What’s value table?

590


What is the purpose of at first and at last?

600


Explain how data is stored in cluster table?

669


Explain how to Handle the internal tables in ABAP?

645


What is generic area buffering in abap?

570


What are the function modules used in f4 help?

646