There is a Database Table of Student Details with Fields Student Id, Student Name, Class ID and Rank. Now how to fetch the first three students with highest ranks from all Classes.
- 4 Answers
- 11491 Views
- Altimetrik, I also Faced
- E-Mail Answers
Answer Posted / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
What is the difference between Exit and Stop?
Explain the differences between se01, se09 and se10?
What are different ABAP editors? What are the differences?
What are the system fields?
From excel to abap - is batch mode possible ? : abap bdc
Have you set up a back ground job ? How to create a background job without a variant ?
What does the extract statement do in extract datasets?
What is the function of the transport system and workbench organiser?
What is size category?
What are the types of windows in sap script?
If A is the super class of B. And both the classes have constructor. We create an object of class B. Then which constructor will be called? If both then in which order?
What is search help exit? : sap abap data dictionary
What are the commands used for interactive reports?
Why is pretty printer user in abap?
What is your approach for writing a bdc program? : abap bdc
