Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
BI Publisher Report- Learning Initiatives including Course number and Title-Learning — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BI Publisher Report- Learning Initiatives including Course number and Title-Learning

Question
11
Views
0
Comments
edited Dec 7, 2022 9:05PM in Learning

Summary:

BI Publisher Report- Learning Initiatives including Course number and Title fetching duplicate rows

Content (required):

Hello All,

I have the SQL code that fetches the learning initiative number, name, Course Number, and Title, but I have found duplicate rows because the Course titles do have the special character '( )' in them. SO, wondering if anyone experienced the same issue and provide a solution to remove the duplicates and fetch the unique rows.

Appreciate your response and assistance.

Thank you,

Thulasi

Version (include the version you are using, if applicable):

22C

Code Snippet (add any code snippets that support your topic, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!