SQL 'count distinct'

Question

1.00/5 (1 vote)

See more:

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.

Posted 7-Mar-10 21:46pm

Brady Kelly

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DaveAuld · Answer 1 · 2010-03-07T22:16:00

Solution 1

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

How does that sound?

Posted 7-Mar-10 22:16pm

DaveAuld

SQL 'count distinct'

1 solution

Solution 1

Add your solution here

Preview 0

SQL 'count distinct'

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us