mysql分组查询问题。面试被问到

Question

用sql语句查询出来红色的结果、

Answer 1

select value, group_concat(id) from test group by value;

Answer 2

group by分组查询

SELECT value, group_concat(id) FROM tablename GROUP BY value;

Answer 3

参考：分组查询与连接