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.
Answers were Sorted based on User's Feedback
Answer / vinay
in the select statement use the max keyword and select up to
3 rows .
Is This Answer Correct ? | 2 Yes | 6 No |
Answer / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
Is This Answer Correct ? | 0 Yes | 6 No |
What are standard layouts sets in the sap script?
What is the use of AT Selection Screen output when we have At selection screen?Can u explain?
what is Cross Applications?
what is the standard program to check the consistency of the partner profiles?
if i want to insert 10 laks MM records and for inserting one record it takes 1 min by using call transaction or session method . so here is there any alternative
Name a few data dictionary objects?
What are MENUEXITS, SCREENEXITS, FUNCTIONEXITS, FIELDEXITS and what is the difference between them ?
How can you Logon your client?
How can you change properties of screen elements dynamically in Module pool Programming ?
wat are the process that can be executed & tracked in a workflow?
What all are the differences did you find in hr module between 4.7 and ECC6 versions
What is Group by in Select statement?