BI Publisher Report- Learning Initiatives including Course number and Title-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):