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 / anonymous
Select Order by Rank and up to 3 rows
| Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
What is size category?
What are the types of indexes in abap?
Explain the different types of mode (run code) in call transaction method?
What are the main events of which are used for logical database?
What is an rfc?
What is the difference between open_form and close_form?
how to create view in bdc..??
What is meant by hide area?
In ALV reporting when u execute your report which event gets triggered.
In select-options, how to get the default values as current month first date and last date by default?
What is a multiple line field?
What is meant by hotspots?
Can a transparent table exist in data dictionary but not in the database physically? : abap data dictionary
What is a logical database?
What are the fields in the memory table ‘screen’?