How to select highest score of each subject or how to select highest income of every month?
- 1 Answers
- 1838 Views
- I also Faced
- E-Mail Answers
Answer Posted / Harshvardhan Aditya
To select the highest score for each subject or the highest income for every month in an RPG program on AS400, you can use sorting and grouping techniques. Here's a basic example for highest income: 1) Create a DS for each record with fields for Income, Month, Year etc. 2) Sort the DS by Income in descending order. 3) Group the records by Month, using the GROUP command. 4) Within each group (i.e., for every month), select the first record which will contain the highest income.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
