mysql - 如何选择具有唯一列值的行并计算计数？

Question

例如，我有这样的表格:我需要通过 ver 选择每个 uniq 列并计算每个 uniq ver 列的总行数我认为每个总数都添加到新列中

table:
id  name  ver 
1   one   5
2   two   5
3   three 6
4   four  6
5   five  8

SELECT，像这样

id  ver total
1   5   2
2   6   2
4   8   1

Answer 1

查询

select MIN(id) as id, ver, COUNT(ver) as total
from your_table_name
group by ver;