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
- 10883 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
please give the remaining answers.
What is the difference between commit-work and rollback-work tasks?
What is the difference between field-group header and other field groups?
What is the table & field to identify the no of items (bottles) stored in one case?
What kind of financial periods exist in SAP? What is the relevant table for that?
In sap script how to print bar code in vertical manner
What is a 'z' report?
Which objects are independent transport objects?
Name some system global variables you can use in abap programs?
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
What is an update type with reference to a match code id? : abap data dictionary
What is sql trace? : abap data dictionary
dynamic programming in sap abap
What is tcode se16? For what is it used.
What is table pool?
