MySQL distinct、group_concat和count问题
MySQL distinct、group_concat和count问题
提问于 2020-10-16 00:03:27
我有一张桌子。
+----------+----------------+--------+
| orderid | barcode | status |
+----------+----------------+--------+
| R-R34184 | K2020101500001 | 1 |
| R-R34184 | K2020101500001 | 1 |
| R-R34184 | K2020101500001 | 0 |
| R-R34184 | K2020101500001 | 0 |
| R-R34184 | K2020101500002 | 2 |
| R-R34184 | K2020101500002 | 2 |
| R-R34184 | K2020101500002 | 2 |
| R-R34184 | K2020101500002 | 2 |
| R-R34184 | K2020101500003 | 1 |
| R-R34184 | K2020101500003 | 1 |
| R-R34184 | K2020101500003 | 0 |
| R-R34184 | K2020101500003 | 0 |
| R-R34185 | K2020101500005 | 0 |
| R-R34185 | K2020101500005 | 0 |
| R-R34185 | K2020101500005 | 0 |
| R-R34185 | K2020101500005 | 0 |
| R-R34185 | K2020101500006 | 0 |
| R-R34185 | K2020101500006 | 0 |
| R-R34185 | K2020101500006 | 0 |
| R-R34185 | K2020101500006 | 0 |
| R-R34185 | K2020101500004 | 0 |
| R-R34185 | K2020101500004 | 0 |
| R-R34185 | K2020101500004 | 0 |
| R-R34185 | K2020101500004 | 0 |
| R-R34185 | K2020101500007 | 0 |
| R-R34185 | K2020101500007 | 0 |
| R-R34185 | K2020101500007 | 0 |
| R-R34185 | K2020101500007 | 0 |
| R-R34185 | K2020101500008 | 0 |
| R-R34185 | K2020101500008 | 0 |
| R-R34185 | K2020101500008 | 0 |
| R-R34185 | K2020101500008 | 0 |
+----------+----------------+--------+我想查询如下: DISTINCT orderby，CONCAT status，COUNT status
+----------+---------------+--------------+
| orderid | status_concat | status_count |
+----------+---------------+--------------+
| R-R34184 | 0,1,2 | 3 |
+----------+---------------+--------------+
| R-R34185 | 0 | 1 |
+----------+---------------+--------------+我尝试了几个代码，任何子查询，分组，但它们都不在一起。如果有人能帮上忙的话谢谢。
回答 2
Stack Overflow用户
回答已采纳
发布于 2020-10-16 00:04:44
这只是聚合函数group_concat()和count()中的group by和distinct
select orderid,
group_concat(distinct status order by status) status_concat,
count(distinct status) status_count
from mytable
group by orderidStack Overflow用户
发布于 2020-10-16 00:04:55
我觉得你想要distinct
select orderid, group_concat(distinct status order by status), count(distinct status)
from t
group by orderid;页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/64375508
复制相关文章
相似问题
腾讯云开发者
