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).
- 7 Answers
- 8049 Views
- Enteg Technologies, I also Faced
- E-Mail Answers
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
Define dispatcher?
What are the other modules integrated with om? : sap abap hr
please any one can tell me How to validate the data in Table maintinance generator?how can u validate the table field values if u r entering the data into fields .it shows record is wrong?wher we can done validation in table maitenance generator before getting the data as out ?
What is a fall back class?
Explain about interactive report?
What is your approach for writing a bdc program? : abap bdc
Explain what is the step-by-step process to create a table in data dictionary?
Explain how is batch input process different from processing on line?
How do you document abap/4 programs? Do you use program documentation menu option?
Does the bdc-insert function allow multiple transactions to be processed by sap? : abap bdc
Hi to all abap gurus iam new to abap and my querry is as follows . and i feel so happy if u give exact anwers ? Querry1: i have one page( named "page1" )in my script with three windows(logo,adress,main windows) my requirement is to display some dynamic data in the script that is list of orders of the customer whn u give the customer number in selction-screen .then we can go for main window only to dispaly dynamic data ? or is there any other option ? then what should we give as apage number in the next page attribute in the header information. suppose if i dont give "page1" in the next page attribute as anext page what will happen ? i mean that dynamic data will be displayed or not ? Querry2: one one more querry incase if we have two pages in my layout .in page1 (3 windows as said above ) and page2 ( only logo and address window ) and no main window in page2. now if we give "page2" as next page in the next page attribute of page1 then that dynamic data will be displayed or not ?
What are hashed tables?
What is the difference between get and get late?
What are Table control and tab strip control in dialog programming ?
What does hide statement do?
