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
What is database utility?
What is the difference between pnp and pnpce? : abap hr
What is value table?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
What are indexes? : abap hr
Explain the differences between sap memory and abap memory?
What data is contained? : abap data dictionary
Explain the data types of internal tables?
if while coding power goes off , how to retrieve the codes?
What are the uses of interactive reporting?
How to pass data from list to report?
Explain what are the various types of selection screen event?
Performance tuning techniques
How many types of tables exists and what are they in data dictionary? : abap data dictionary
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?