on 04-14-2016 4:26 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
7 | |
3 | |
2 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.