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
- 11493 Views
- Altimetrik, I also Faced
- E-Mail Answers
Answer Posted / sutirtha
Select Order by Rank and up to 3 rows
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are the different types of the sap abap data dictionary objects?
What are the events in ABAP language?
Can you create an internal table dynamically?(at run time)
what is the exact code that shoud be implimented in sap note
wat is the default file name of BAPI trace?
– Programming using BAPI : Create Debit Memo Request (DMR) with reference to Sales Order and update the delivery number and PO number in the newly created DMR. Send the spool of the report by E-mail if the E-mail option is enabled. Selection Screen Required: Sales Org Delivery type Sales document type Optional: Planned Goods movement date Option to choose E-Mail E-mail Address Output device Output Output should display both successful and unsuccessful creation of DMR with the following fields, Success/Error (S/E) Sales Document number Delivery number New Debit memo request number Error message Tables TVAK, TVCPA, VBAK, LIKP, LIPS
Can we define our own match code id's for sap matchcodes? : abap data dictionary
What is meant by stacked list?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
what are the 2 other types of views, which are not allowed in release 3.0? : abap data dictionary
What are your ways to performance optimization?
Explain the advantage of structures?
What are the different types joins?
Describe the data classes?
Can a transparent table exist in the data dictionary but not in the database physically?
