How to find more than one entry for a given column ID 2

[hapax]

I have a table named Comments.
It has columns CommentID, GameID, UserID.

I want to find out if any UserID has more than one CommentID for any given GameID (they shouldn't). Could someone please tell me a SELECT to accomplish this?

Many thanks

 

[KeertanaCR]

Try the following:

select count(commentId), UserId, GameID
From Comments
Group by UserID, GameID
Having Count(CommentId)>1

Hope this helps!

Thank you
Keerthana

 

[PHV]

SELECT GameID, UserID, COUNT(*)
FROM Comments
GROUP BY GameID, UserID
HAVING COUNT(*)>1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886