Question

php mysql 统计数据重复的问题

Id userid username fraction
1 555 aaa 6
2 666 bbb 6
3 555 aaa 12
4 777 ccc 7

select *, count(distinct name) from table group by name

最终结果

aaa 18 2
bbb 6 1
ccc 7 1
$sql = "select *, count(distinct name) from table group by name";
$query = $db->query($sql_log1);
while($log1 = $db->fetch_array($query))
{
$log_list1[] = $log1;
}

Answer 1

select username,sum(fraction), count(*)
from 表名
group by username