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 / shaheen

This can be achived by '...group by' addition in the select
statement.

Regards,
Shaheen

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?

1731


Explain the function module in bdc?

582


What are the different functions used in sap script?

534


What are the events driven batch jobs?

594


Why do we use dynamic where conditions?

878






What is tcode se16? For what is it used.

591


What is the function of the transport system and workbench organiser? : abap data dictionary

620


Explain the use of table maintenance allowed?

546


data:zxyz type xyz. where xyz is a standard sap structure where it contains data type fields and line type (refer to other structure) fields. my question is how to assign values to field zxyz-str-matnr where str is a structure inside xyz structure.

1899


What are the function modules that are generated when you activate a lockobject? : sap abap data dictionary

577


while implementing badi what are the tables u find??

3623


How do I find the output type of a table or a program?

593


What is meant by hide area?

660


What is the purpose of at first and at last?

600


​​What is amdp (abap managed data procedures)?​​

644