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
What are the function modules used in a sap script driver program?
What is structure?
Interactive Report that list purchase order details of a vendor. When the user double clicks on material number it shows detail list with fields matkl, meins, brgew, ntgew, gewei.The selection screen consist of sales organisation, distribution channel and material number. plz mention the detail coding Tahnks, Rahul
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
What are the check tables and value tables?
hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display
How do you control printer functions from sapscript?
Which one is better joins or views and why?
Differentiate screen painter from menu painter.
Name the special commands of list?
What are the main events of which are used for logical database?
What are the dynapro keywords?
What is the use of at new statement ?
What are the page windows?
What is a subroutine?