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
What is tcode se16. For what is it used. Explain briefly?
How to write a code in tab control? : abap bdc
What are the two ways of producing a list within a transaction?
What is pass by value and what is pass by reference? Which is better?
How do you write manual bdc session method? : abap bdc
What will you code in start-of-selection & end-of-selection ?
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary
How to creat transactions? : abap data dictionary
any 1 having notes on SAP-ABAP certification, or even if any 1 could provide the url for getting notes on SAP-ABAP certification, would be appreciated.
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
What are the difference between pool tables and transparent tables?
THANKS ALL. i CLEARED THE INTERVIEW OF INFOSYS BASED ON THIS QUESTION SET. IT REALLY WORKS. LONG LIVE ALLINTERVIEW.COM
what is sales order confirmation and how can do design it in webdynpro. what is Tcode for the same?
What is exception class and test class. How to use it?
What are the different types of the sap abap data dictionary objects?