very eazy :-)
just use sum function
group by user and date.
then use where the sum is > then 0 (then he had at least one on that day with a value of 1)
* if you post DDL+DML we could help you with the quey it self
No comments:
Post a Comment