SQL“计数不相同" [英] SQL 'count distinct'

问题描述

我有一张表，上面有调查答复.每个记录都有一个评分者，评分者以及评分者与评分者之间的关系类型.如何获得每个被评估人的每种评估人的数量?

这应该很容易，但是我处于压力之下并且头脑冻结.

I have a table with survey response answers. Each record has a ratee, rater, and the type of relation between ratee and rater. How do I get the count of each kind of rater per ratee?

This should be easy, but I''m under preasure and having a brain freeze.

推荐答案

SELECT        Ratee, Rater, COUNT(Rater) AS RaterCount
FROM            Results
GROUP BY Ratee, Rater

听起来如何?

How does that sound?

这篇关于SQL“计数不相同"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！