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

How can I count how many duplicates there are for each distinct value in sqlite?(如何计算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;

这篇关于如何计算sqlite中每个不同值有多少重复?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！