Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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):
Tagged:
0