Dear experts,
Let me explain my condition. I have a table as below:
and I would like to count how many days is these men active. And the query result should be like this:Code:
NAME DATE JOE 1-Jan-12 TED 1-Jan-12 MARK 2-Jan-12 JOE 3-Jan-12 JOE 3-Jan-12 MARK 3-Jan-12
Your help is very appreciated. Thank you.Code:
NAME DAYS_ACTIVE JOE 2 TED 1 MARK 2
Sincerely,
Harapan