Posted by markc600 on 12/18/06 16:30

select date,
user,
sum(case when transaction_type ='debit' then amount else 0 end)
/
sum(amount) as perc_Debit
from mytable
group by date, user

[Back to original message]