Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
How to use MAX Date in OTBI
Content
Hi
I'm getting multiple work relationship records, I would like to return only the latest work relationship record. How can use MAX function to select the latest row?
ex. we have partners and there is Partnership Start Date. if partner get promoted to next level I'm getting 2 rows for same partner.
| Name | Partner Level | Start Date |
| abc | Level1 | 12/12/2019 |
| Level2 | 12/12/2020 | |
| xyz | level3 | 12/12/2020 |
So in this ex, I want one row for abc with start date 12/12/2020.
0