我想在使用計數后對 3 個不同的值求和。這是我必須獲得 3 個不同值的查詢。
SELECT f.filmid, filmtitel, count(award_type)
FROM film F
INNER JOIN film_award_uitreiking FAU ON F.filmid = FAU.filmid
INNER JOIN Film_award FA ON FA.awardid = FAU.awardid
WHERE fau.filmid = 4317
GROUP BY FA.award_type
ORDER BY count(fau.awardid) DESC;
現在我想把它們總結在一起有什么建議嗎？
uj5u.com熱心網友回復：
select sum(atcount) from
(
SELECT f.filmid, filmtitel, count(award_type) as atcount
FROM film F
INNER JOIN film_award_uitreiking FAU ON F.filmid = FAU.filmid
INNER JOIN Film_award FA ON FA.awardid = FAU.awardid
WHERE fau.filmid = 4317
GROUP BY FA.award_type
) x
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/358148.html
下一篇：如何獲得以下格式的sql結果