56,678
社区成员
发帖
与我相关
我的任务
分享
select
qikanmingzi,group_concat(distinct qishu)
from
tablename
group by
qikanmingzi
select qikanmingzi,group_concat(qishu) qishu
from phome_ecms_news
group by 1;
select qishu,qikanmingzi
from phome_ecms_news
group by qishu,qikanmingzi;
select qikanmingzi ,qishu from phome_ecms_news where 1 group by qikanmingzi ,qishu ;