sql - 在另一个表中按计数排序

Question

我有 2 个 sql 表

1.类别表

-id
-name
-url
-content

2.条目表

-id
-title
-content
-cat //category
-view
-author

我想按条目表中的类别总数对所有类别进行排序

我想根据此查询返回的值对类别进行排序：

  SELECT count(cat) as catcount, 
         cat 
    FROM entry 
GROUP BY cat 
ORDER BY catcount DESC 

此查询当前返回两个结果。我要打印的区域中有 20 个地方。我想在空字段中写入随机字段

  sample data: 
kitap
acil

expected data:
kitap
acil
random category.name 18 piece

标签： sql

Answer 1

你只是想要一个left join？

SELECT c.id, COUNT(e.id) as catcount
FROM category c LEFT JOIN
     entry e
     ON c.id = e.cat
GROUP BY c.id 
ORDER BY catcount DESC ;