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 / vinay
in the select statement use the max keyword and select up to
3 rows .
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
How do you convert non-char field into char type fields ?
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
Differentiate between static and dynamic step loops?
What are the update types possible? : abap data dictionary
Explain the disadvantages of logical databases?
Difference between sap script and report?
How can we determine a vendor is Bloc/Unblock from the table LFA1?
Explain the uses of the simple maintenance interface? : sap abap hr
Which function module reads the data for particular infotype ? : abap hr
Why do we use logical blocks in abap program?
What is a data dictionary? : abap data dictionary
What is the table buffer? Which type of tables used this buffer?
What are table clusters?
Explain about sap fico testing and the tools used? : abap bdc
How are BAPI different from normal function modules?