我有两张桌子:
每个作家都有她写的书的清单。我想让所有的作家知道他们每个人写的书的数量。有办法在一个查询中做到这一点吗?
发布于 2017-12-24 17:33:12
我相信这对你有用。不确定是否有更有效的方法:
select id, (select count(*) from books where books.writer_id = writers.id ) count from writers发布于 2017-12-24 17:38:38
我更喜欢以下非嵌套版本:
SELECT
writers.id,
writers.name,
count(books.*) as BookCount
FROM
writers
LEFT JOIN books ON writers.id = books.writer_id
GROUP BY
writers.id,
writers.namehttps://stackoverflow.com/questions/47962563
复制相似问题