Loading

Group by values

Group by values

Ramco Ramco

3y720SQL

Hi

I have below data .

Group 5C

Group 5B

Group 3C

Group 4C

Group 3E

Group 5C(i)

Group 4C(i)

I want to get data like this

Group 5C , Group 5C(i)

Group 5B

Group 3C

Group 4C , Group 4C(i)

Group 3E

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul3y ago
```
SELECT CONCAT(group_name, IF(group_name LIKE '%(i)', '', CONCAT(' , ', (SELECT group_name FROM groups g2 WHERE CONCAT(g1.group_name, '(i)') = g2.group_name)))) AS grouped_names
FROM groups g1
GROUP BY group_name
ORDER BY group_name;
```
This query will concatenate the group names together based on the specified conditions. The IF statement is used to exclude the "(i)" suffix for group names that already have it. The subquery is used to retrieve the corresponding "(i)" group name, if it exists, and concatenate it with the original group name.
0