select qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi;
你是不是想要这个啊 select qikanmingzi,group_concat(qishu) qishu from phome_ecms_news group by 1;
select qikanmingzi ,qishu from phome_ecms_news where 1 group by qikanmingzi ,qishu ;
select qishu,qikanmingzi from new group by qishu,qikanmingzi;
select qikanmingzi,group_concat(distinct qishu) from tablename group by qikanmingzi
select distinct qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi; 其中 distinct可以不写。默认的就是去掉重复的。 select qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi;
from phome_ecms_news
group by qishu,qikanmingzi;
select qikanmingzi,group_concat(qishu) qishu
from phome_ecms_news
group by 1;
select qikanmingzi ,qishu from phome_ecms_news where 1 group by qikanmingzi ,qishu ;
from new
group by qishu,qikanmingzi;
qikanmingzi,group_concat(distinct qishu)
from
tablename
group by
qikanmingzi
其中 distinct可以不写。默认的就是去掉重复的。
select qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi;