Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12231 Views
- Altimetrik, I also Faced
- E-Mail Answers
Answer Posted / gaurav walia
first sort the rank field by descending.....den select rank up to 3 rows...
| Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?
What is an interactive report?
SAP query how to use end users?
Can multiple abap systems connect to abap database?
What is a variable in the sap abap?
dynamic programming in sap abap
How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.
Which transaction code can I use to analyze the performance of abap program?
Can you delete data element, which is being used by table fields?
Explain what are extracts?
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
Why grouping of fields is required? What is the max no of modification groups for each field?
Select query optimisation
What is smart forms? : abap hr
how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul
