Heizengberg
Eternal Poster
- Joined
- Jul 12, 2017
- Posts
- 597
- Reaction
- 120
- Points
- 282
mga sir ganto kasi table struct ko.
|emp_id| type | date | amount
----------------------------------------------------------------
| 1 | transpo | 2018-06-01 | 50
| 1 | others | 2018-06-01 | 50
| 1 | grade | 2018-06-01 | 50
| 2 | transpo | 2018-06-01 | 50
| 2 | others | 2018-06-01 | 50
| 2 | grade | 2018-06-01 | 50
| 1 | transpo | 2018-06-02 | 100
| 2 | transpo | 2018-06-02 | 90
ang gusto ko sana is makuha yung pinaka latest na allowances nila per type (transpo,others,grade) for each employee and each type
sample result for employee 1:
grade - 50
transpo - 100
others - 50
|emp_id| type | date | amount
----------------------------------------------------------------
| 1 | transpo | 2018-06-01 | 50
| 1 | others | 2018-06-01 | 50
| 1 | grade | 2018-06-01 | 50
| 2 | transpo | 2018-06-01 | 50
| 2 | others | 2018-06-01 | 50
| 2 | grade | 2018-06-01 | 50
| 1 | transpo | 2018-06-02 | 100
| 2 | transpo | 2018-06-02 | 90
ang gusto ko sana is makuha yung pinaka latest na allowances nila per type (transpo,others,grade) for each employee and each type
sample result for employee 1:
grade - 50
transpo - 100
others - 50