How to use MAX Date in OTBI
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|
So in this ex, I want one row for abc with start date 12/12/2020.