SQLite 计数、分组和按计数排序

发布于 2024-11-25 03:33:49 字数 396 浏览 2 评论 0原文

我有一个如下所示的表格：

FOO  BAR  BAZ
----+----+----
foo1 bar1 baz1
foo2 bar3 baz2
foo3 bar1 baz3
foo4 bar1 baz4
foo5 bar3 baz5
foo6 bar1 baz6
foo7 bar2 baz7

因此，我想获取每个条形在表格中出现的次数。所以，我正在寻找的输出如下所示：

BAR   COUNT
-----+-----
bar1    4
bar3    2
bar2    1

我可以进行查询吗SQLite 中有这样的东西吗？我想这应该很简单，但我无论如何都不是 SQL 程序员，我只需要这个简单的查询作为 python 脚本的一部分。谢谢。

原文

I have a table that looks like this:

FOO  BAR  BAZ
----+----+----
foo1 bar1 baz1
foo2 bar3 baz2
foo3 bar1 baz3
foo4 bar1 baz4
foo5 bar3 baz5
foo6 bar1 baz6
foo7 bar2 baz7

And as a result I would like to get the count of how many times each bar appeared in the table.. so, the output I'm looking for looks like this:

BAR   COUNT
-----+-----
bar1    4
bar3    2
bar2    1

Can I do a query for something like this in SQLite? I guess it should be pretty easy, but I am not an SQL programmer by any means, and I just need this simple query as a part of a python script.. Thank you.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

红墙和绿瓦 2024-12-02 03:33:49

SELECT foo, count(bar) FROM mytable GROUP BY bar ORDER BY count(bar) DESC;

group by 语句告诉聚合函数按列对结果集进行分组。在本例中，“按条形分组”表示计算条形列中的字段数量，并按条形的不同“类型”进行分组。

更好的解释在这里：http://www.w3schools.com/sql/sql_groupby.asp

SELECT foo, count(bar) FROM mytable GROUP BY bar ORDER BY count(bar) DESC;

The group by statement tells aggregate functions to group the result set by a column. In this case "group by bar" says count the number of fields in the bar column, grouped by the different "types" of bar.

A better explanation is here: http://www.w3schools.com/sql/sql_groupby.asp

回复收藏 0 原文

~没有更多了~