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
How to creat transactions? : abap data dictionary
What will be your approach towards optimizing legacy code? Will you suggest change in technology? Does OO ABAP bring any performance benefits? How will you deal with queries in a loop? How will you optimize nested loops?
How the at-user command serves mainly in lists?
wat is the default file name of BAPI trace?
What are the uses of table pool or table cluster.
what is field string ? & where we are using field strings?
What is a table attribute? : abap data dictionary
What is Group by in Select statement?
What are system fields for secondary lists?
What is the difference between sum and collect?
Differentiate between report and dialog program
What do you mean by batch data communications programming?
What is constructor expression in nw abap 7.4?
Define database layer?
Give an example of interface from your project explaining why you used it?