如何计数和分组查询以获得正确的结果？ [英] How to count and group query to get proper results?

问题描述

我遇到问题，请查看我的数据库：

  ------------- ------ 
 | id | article_id | 
 ------------------- 
 | 1 | 1 | 
 | 2 | 1 | 
 | 3 | 1 | 
 | 4 | 2 | 
 | 5 | 2 | 
 | 6 | 3 | 
 | 7 | 3 | 
 | 8 | 3 | 
 | 9 | 3 | 
 | 10 | 3 | 
  

我想收到类似这样的内容（按票数排序，从最大到最小）： p>

  --------------------------- 
 | id | article_id |投票| 
 --------------------------- 
 | 1 | 3 | 5 | 
 | 2 | 1 | 3 | 
 | 3 | 2 | 2 | 
  

您能否帮我写适当的sql查询？

ORDER BY表决DESC;

I have a problem, please see my database:

-------------------
| id | article_id |
-------------------
| 1  |      1     |
| 2  |      1     |
| 3  |      1     |
| 4  |      2     |
| 5  |      2     |
| 6  |      3     |
| 7  |      3     |
| 8  |      3     |
| 9  |      3     |
| 10 |      3     |

And I want to receive something like this (order by votes, from max to min):

---------------------------
| id | article_id | votes |
---------------------------
| 1  |      3     |    5  |
| 2  |      1     |    3  |
| 3  |      2     |    2  |

Could you please help me to write proper sql query?

解决方案

SELECT article_id, COUNT(article_id) AS votes
FROM votes_table
GROUP BY article_id
ORDER BY votes DESC;

这篇关于如何计数和分组查询以获得正确的结果？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！