Simple count query - just can't do it

[lead2gold]

Ok, i guess my brain isn't working...
What am i doing wrong?
[code]
SELECT count( gid )
FROM table
WHERE sid =1
GROUP BY gid
[/code]
the above returns 2.

I currently have 2 entries in the entire database (to make testing easy).
What i want to have returned is 1 because both entries have the same gid.

How do i manipulate the above to acomplish this?

[shoz]

[code]
SELECT
COUNT(DISTINCT gid) AS num
FROM
tablename
WHERE
sid = 1
[/code]

[lead2gold]

I'll give some grace for that!

Thanks a million!