What am i doing wrong?
SELECT count( gid ) FROM table WHERE sid =1 GROUP BY gidthe 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?