选择按频率排序的顶级不同结果

2021-12-30 00:00:00 sql count distinct mysql

我的表有两列:id 和 name.数据如下所示:

My table has two columns: id and name. The data looks like this:

id | name
----------
1    Jeff
2    Sam
3    Carl
4    Sam
5    Carl
6    Jeff
7    Dave
8    Jeff

我想获得的是:

name | frequency
----------------
Jeff      3
Carl      2
Sam       2
Dave      1

本质上,我需要一个 SQL 查询来计算表中的唯一名称,并按频率对它们进行排序.如果重要的话,我正在使用 MySQL.

Essentially, I need an SQL query that counts the unique names within the table, and sorts them by their frequnecy. I'm using MySQL if it matters.

谢谢.

推荐答案

我没有测试过,所以语法可能不完美,但是像这样的东西呢:

I haven't tested it, so the syntax might not be perfect, but what about something like this :

select name, count(*) as frequency
from your_table
group by name
order by count(*) desc

应该给你唯一的名字和每个名字在表格中出现的相应次数,按那个数字排序.

Should give you unique names and the corresponding number of times each name appears in the table, ordered by that number.

相关文章