|
heya guys, i got an sql question
i have a table called users with a
userno column, a tranid column and a type column
im trying to get the userno's and the count of the
userno's from this table for type '1'.
i was doing this:
sel userno count(userno)
from users
where type=1
group by userno
that works good however i want to make it only
count distinct tranid's cause this is a summary of another peice of data which
only shows distinct tranid's and it would be nice if they matched hehe
(:
Is this possible with sql?
Thanks!
Atrix
|
