How to get the latest completion date along with the new due date? (Learning Assignment)

Question

Summary:

We want to get in the report the latest completion date of the learner and the new due date in each course in 1 row for each learner. However, we are getting 2 rows. Is our requirement possible? Please check the attached screenshot and the SQL we created.

Below is the SQL used.

Orginal SQL.txt

Thank you!

Raghavan p-Oracle · Answer

Hi Kobe,

You may try the pivot table.

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-4E6D9DBB-0029-4F1C-ACC0-6FD48F7C68A3.htm#BIPRD2283

Regards,

Raghavan P