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 / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
Is it possible to bring select option in module pool screens?
Which transaction code is used executing a report (type 1 program)? : abap data dictionary
Differentiate screen painter from menu painter.
What are base tables of an aggregate object?
Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.
What is a multiple line field?
Select query optimisation
Explain different types of attributes of function module?
How many lists can a program can produce?
When value table becomes check table?
What are the different types of parameters?
What is sql trace? : abap data dictionary
What is the purpose of sum statement?
What is an “on input filed” statements?
How we can give authorization on the fields of table control in a dialog-programming?