Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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