Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Group Concatenate in SAP MII MDO

I want to concatenate all the values of column in a single row with GROUP BY Clause. For Example:

SELECT id, subject, GROUP_CONCAT(username SEPARATOR ', ') usernames FROM some_table GROUP BY id, subject 

In MySQL.

How can I g about performing a similar function in SAP MII SELECT MDO Query?

Tags:
Not what you were looking for? View more on this topic or Ask a question