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.
Answers were Sorted based on User's Feedback
Answer / vinay
in the select statement use the max keyword and select up to
3 rows .
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
Is This Answer Correct ? | 0 Yes | 6 No |
When the get cursor command used in interactive lists?
Difference between domain and data element? What are aggregate object?
What is append structure?
HOW DO WE JOIN TWO INTERNAL TABLES USING READT STATEMENT??
Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?
tcode to find applicatin server directories?
To how many tables can an append structure be assigned. : abap data dictionary
can we insert two records in internal table? if yes give code.
Explain buffering concept usage?
What are the different types of loops in the sap abap?
How can I make a differentiation between dependent and independent data?
What is field catalog?