Hi all.
Could someone help me to understand the answer_set logic?
I have a MWO survey that has been answered 4 times in the same day by the same employee.
But the answer set has repeated 2 times.
If this logical is correct, How could I group a snwer set in this situation?
I thought the logic was 1,2,3,4
At the end of the day, I need to create a quickreport setting a parameter with one of the answers like the example bellow.
I’m using this way in the select to do this but considering the answer set.
min(v2.item_description) over (partition by c.emp_no, trunc(c.DATE_CREATED), c.answer_set ) as car
Tks a lot for help