mysql - 计数问题

Question

我需要按艺术家计算标题

SELECT artist,
    title,
    label,
    COUNT(title) AS countTitles 
FROM table 
WHERE domain = 'domain.com' 
GROUP BY title 
ORDER BY countTitles DESC;

但结果只能让我知道标题的数量 - 不同艺术家的作品。

我想要:

artist1 - title1a
artist1 - title2a
artist1 - title1a
artist1 - title1a
artist1 - title1a

我想这样数

artist1 - title1a - 4
artist1 - title2a - 1

我做错了什么？

Answer 1

您不应该选择不在 GROUP BY 中的列，即使 MySQL 对此进行了扩展。

SELECT artist, title, 
    COUNT(*) AS countTitles 
FROM table 
WHERE domain = 'domain.com' 
GROUP BY artist, title
ORDER BY countTitles DESC;