如何计算sqlite中每个不同值有多少重复?

2021-12-30 00:00:00 sum count distinct sqlite

我有一张桌子:

ref,type
1,red
2,red
3,green
4,blue
5,black
6,black

我希望 sqlite 查询的结果是:

I want the result of a sqlite query to be:

red,2
green,1
blue,1
black,2

我认为最难做的事情是找到一个与我的问题相匹配的问题?那么我相信答案就在眼前....

I think the hardest thing to do is find a question to match my problem? Then I am sure the answer is around the corner....

:)

推荐答案

一个快速的谷歌给了我这个:http://www.mail-archive.com/sqlite-users@sqlite.org/msg38339.html

A quick google gave me this: http://www.mail-archive.com/sqlite-users@sqlite.org/msg38339.html

select type, count(type) from table group by type;

相关文章