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

Does every abap/4 have a modular structure? : abap modularization

919


Define the various contents of technical specifications ?

882


Can we use transfer dataset to transfer data in internal table ?

1908


Define structure in abap data dictionary?

827


What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary

1635


How many types of tables exists and what are they in data dictionary?

1424


How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?

816


How will you transfer data into a file in application server?

827


In selection screen I have three fields, plant mat no and material group. If I input plant how do I get the mat no and material group based on plant dynamically?

924


What is the difference between rfc and bapi function modules? : abap bdc

876


Can you create a table with fields not referring to data elements? : abap data dictionary

1069


What are the types of subroutines?

867


What is the use of dequeue function module? : sap abap data dictionary

913


What is an Open Item in SAP? How will you find an Open Item in SAP?

858


if u take one worst program,in this program user write the logic is session method.in that program user can get some errors ,that errors we will see in call transaction method,how it is possible.?

1933