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.
Answer Posted / vinay
in the select statement use the max keyword and select up to
3 rows .
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How do you use tab sets in layout sets?
What actually happens in real-time recruitment? : sap abap hr
Write syntax for message error (report)?
What is use of transparent table in abap? How it is different from pool tables?
Define the various contents of technical specifications ?
What is the differences between abap and ooabap. In which situation we useooabap?
Static and instance variable and method with live example. Why and when to use
Differentiate between the uline and write: sy-uline statements if any?
What is the tcode to create indexes?
1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?
In which table the material master data is stored?
Final class
How do you import pay scale data from non sap to sap? : sap abap hr
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
How would you set the formatting options statically and dynamically within a report?