Concatenate Sql column

Question

SELECT DISTINCT a.assessement_group_id,
                b.title as dataa
FROM assessment_group a
JOIN assessment_category b
WHERE a.assessement_group_id = b.group_id

I am using the join to display the data.the result are shown below

100     Partner Business Profile
99      Partner Activation
99      ajay test
100     ajaytest123

But i want this type of answer

   100   Partner Business Profile,ajaytest123
   99     Partner Activation,ajay test

Duplicate question. Check [this](http://stackoverflow.com/questions/8516212/how-to-concatenate-values-with-same-id-in-sql) and [this](http://stackoverflow.com/questions/6603319/concatenate-values-based-on-id) answere. — Lonkey, Jul 20 '16 at 05:02
Possible duplicate of [MySQL Results as comma separated list](http://stackoverflow.com/questions/662207/mysql-results-as-comma-separated-list) — Drew, Jul 20 '16 at 05:49

Tim Biegeleisen · Accepted Answer · 2016-07-20T05:18:15.307

You can use GROUP_CONCAT(DISTINCT ...) along with GROUP BY to get the output you want:

SELECT a.assessement_group_id,
       GROUP_CONCAT(DISTINCT b.title)
FROM assessment_group a
INNER JOIN assessment_category b
    ON a.assessement_group_id = b.group_id
GROUP BY a.assessement_group_id

SQLFiddle

By the way, I replaced your old-style implicit join syntax with an explicit INNER JOIN. It is generally considered bad practice now to put join conditions into the WHERE clause.

score 1 · Answer 2 · answered Jul 20 '16 at 05:03

Try something as follows, hope this helps

select id, group_concat(`dataa` separator ',') as `dataa`
from
(
  SELECT distinct a.assessement_group_id id, b.title as dataa 
  from assessment_group a JOIN assessment_category b 
  WHERE a.assessement_group_id=b.group_id
) tbl
group by id;

score 0 · Answer 3 · answered Jul 20 '16 at 05:01

0

See the MySql GROUP_CONCAT() as part of a grouped query.

http://dev.mysql.com/doc/refman/5.7/en/group-by-functions.html

You would add a GROUP_BY assessement_group_id to the end of the query, for example.

answered Jul 20 '16 at 05:01

redolent

4,159
5
37
47

score 0 · Answer 4 · answered Jul 20 '16 at 05:04

In mySql you can use the GROUP_CONCAT function, see here more details: http://dev.mysql.com/doc/refman/5.6/en/group-by-functions.html#function_group-concat.

In your initial query you need to add GROUP_CONCAT(b.title) in select clause and also a group by after assessement_group_id.

score 0 · Answer 5 · answered Jul 20 '16 at 05:11

0

This one will help you

 SELECT A.ASSESSEMENT_GROUP_ID, GROUP_CONCAT(B.TITLE SEPARATOR ' , ') AS DATAA FROM  ASSESSMENT_GROUP A, ASSESSMENT_CATEGORY B WHERE A.ASSESSEMENT_GROUP_ID=B.GROUP_ID GROUP BY A.ASSESSEMENT_GROUP_ID;

answered Jul 20 '16 at 05:11

Goutham

52
1
1
9

Concatenate Sql column

5 Answers5

SQLFiddle