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
- 10877 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
Power is interrupted while transferring data from internal table to application server. How will you determine many records are transferred in session method and call transaction method? : abap bdc
Explain what is the difference between sy-tabix and sy-index? Where it is used?
What are the disadvantages of abap query tool?
What are the different types of luws. What are they?
when are objects are passed from task to the change request?
Why is pretty printer user in abap?
What are the other modules integrated with om? : sap abap hr
What are interface/conversion programs in SAP?
How is conversion of data types done between abap/4 & external level?
What is the difference between field-group header and other field groups?
What is the meaning of table buffer? This buffer is used by which type oftable?
What are the restrictions on subscreens?
Explain how do you move on to the next screen in interactive reporting?
What is the difference between native sql & open sql? : abap data dictionary
What is modularization and its benefits?
