cancel
Showing results for 
Search instead for 
Did you mean: 

Group Concatenate in SAP MII MDO

former_member338431
Discoverer
0 Kudos

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?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Better option could be create an MDO with SQL Query template of type FixedQueryWithOutput.

SELECT MDO Query has limited support on SQL ANSI.

Hope this Helps.

Parandhaman