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 / 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 prerequisites for creating foreign key relationship?
What are field symbols and field groups? Have you used component idx of structure clause with field groups?
What are your ways to performance optimization?
B -Credit Note report Selection Screen Ranges: Creation date Sales Org Sold to Party Selection condition: Document Category – VBTYP should be ‘O’ Table to be used: VBRK, VBRP,VBPA,ADRC List the CR order types or credit billing type by customer number (or selected customer) and displays the: - Billing Document date (FKDAT) - Customer number (KUNRG) - Name of the reseller (on top of the SAP No) (NAME1) - Billing document number,(VBELN) - order reason (AUGRU_AUFT) - Amount (NETWR) - Currency (WAERK) Group Currency wise, billing type wise sum of Net value. When user double click on field ‘Billing Document #’ , display the document in VF03 Do this using OO ABAP.
Does the call transaction method allow multiple transactions to be processed by sap? : abap bdc
Can you create a table with fields not referring to data elements? : abap data dictionary
What are the two statements which are required in an abap program to output an icon using a write statement?
if while coding power goes off , how to retrieve the codes?
What are interactive reports?
Explain how many types of tables exist and what are they in data dictionary?
What is the function of the correction system?
What is sap luw or update transaction?
Can a filed occur in several field groups?
How does the system handle roll areas for external program components?
What is a view? : abap data dictionary