SQL中求相同列的和,保留title不相同的记录,求出对应的全部click的和,并输出

图片说明

 select title,sum(click)
from table_name
group by title

select sum(_click),_title from table_test group by(_title);

select _title,sum(_click) from 表名 group by _title

select count(1),_title,sum(_click) from table_test group by(_title);