07-28-2011 01:55 PM
I have a transactoin table with transactionid and contactid.
There can be same transactionid for multiple contacts.
I'm trying to figure out how to get the count of unique transactionid AND contactids, but im not sure how to use the 'distinct' function correctly to get it, so far i have:
count (distinct transactionid contactid) as unique
im getting a syntax error on the count statement.
thanks for your help.
Need further help from the community? Please ask a new question.