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
Which commands are used for interactive reports?
What is off cycle payroll run
What are the two different ways of building a match code object?
What are the update types possible? : abap data dictionary
Which objects are independent transport objects?
What is the difference between select statement and provide statement ? : abap hr
What is asynchronous and synchronous update?
What is the differences between structure and table in data dictionary in abap?
Explain lsmw?
What are the types of data types in the sap abap?
How can we upload a text file having delimiters in to legacy system?
How is conversion of data types done between abap/4 & external level?
in bdcsome times we get the ok code for "enter" wrongly instead of '/00'.what is the reason.how we can exceed this problem.
What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc
i want to add 2 records to a table but the last field in the table is 1000 char long.Is it possible?if yes how?