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
Explain what is the purpose of sap script?
What is exception class and test class. How to use it?
In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plantdynamically?
What is the syntax for call transaction? : abap bdc
What is the bapi?
How do you restrict the data to be entered in the payroll area? : sap abap hr
HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)
Explain the advantages/disadvantages of logical databases?
How many primary keys can be created for a table?
what is the difference between Blocked ALV and interactive ALV?
Which type of tables used this buffer?
Fallback class
Mention the various databases integrities?
How do you execute the payroll
Mention what is alv programming in abap?