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 |
What are Views, how they were useful. Types of Views
when we use the SELECT statement along with FOR ALL ENTRIES then what type of validations we have do before executing this statement
2 Answers Cap Gemini, Mphasis, TCS,
Explain how to create any functions?
n an internal table you want to modify content of a particular field in a row. How to do it?
How do you define an internal using types?
with table control?
Where the payroll results are stored
What does an exec sql statement do in abap? What is the disadvantage of using it?
What are the different types of data dictionary objects?
How to call other programs?
tell me about status codes?
What two statements are required in an abap program to output an icon using a write statement?