关于group语法的使用

Question

select qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi

Answer 1

select qishu,qikanmingzi 
from phome_ecms_news 
group by qishu,qikanmingzi;

Answer 2

你是不是想要这个啊
select qikanmingzi,group_concat(qishu) qishu 
from phome_ecms_news 
group by 1; 

Answer 3

select qikanmingzi ,qishu  from phome_ecms_news  where 1 group by qikanmingzi ,qishu ;

Answer 4

select qishu,qikanmingzi 
from new
group by qishu,qikanmingzi;

Answer 5

select
    qikanmingzi,group_concat(distinct qishu)
from
    tablename
group by
    qikanmingzi

Answer 6

select  distinct qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi;
其中 distinct可以不写。默认的就是去掉重复的。
select qishu,qikanmingzi from phome_ecms_news group by qishu,qikanmingzi;