Welcome to the Oracle Analytics Online Forum!
We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
How to get the latest completion date along with the new due date? (Learning Assignment)
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.
Thank you!
Tagged:
0
Answers
-
Hi Kobe,
You may try the pivot table.
Regards,
Raghavan P
1