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.
- 4 Answers
- 11490 Views
- Altimetrik, I also Faced
- E-Mail Answers
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 are different data types in abap/4?
How will you insert record in a sorted table
What are the two different ways of building a match code object?
How do you convert non-char field into char type fields ?
What is luw or data base transaction ?
What are field groups?
What are the system fields you have worked with? Explain?
How do you populate data into a multiple line field? : abap bdc
What are base tables of an aggregate object?
How to define selection screen?
What is tcode se16. For what is it used. Explain briefly?
What is going life actually? What is the role of a functional consultant in it? : sap abap hr
How do we assign dynamic views while creating material master and generating bdc? : abap bdc
How is conversion of data types done between abap/4 & external level? : abap data dictionary
What data is contained in data dictionary? : abap data dictionary
