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 basic difference internal tables and database tables? : abap data dictionary

560


Difference between user exit and badis?

607


Can we access static attribute from instance method

988


What are the types of views? : sap abap data dictionary

634


while implementing badi what are the tables u find??

3615






What are the differences between domain and data element?

570


What are the advantages of logical databases?

614


What is use of transparent table in abap? How it is different from pool tables?

626


What is asynchronous and synchronous update?

569


Difference between sy-tabix and sy-index? Where it is used? Can you check sy-subrc after perform?

602


How do you write transaction programs in sap?

574


What are the different types of luws. What are they?

622


What is the step-by-step process to create a table in data dictionary? : abap data dictionary

684


What are the time related infotypes? : abap hr

607


What is the advantage of structures?

577