|
|
Posted by Ed Murphy on 12/18/06 16:37
isdeveloper@hotmail.com wrote:
> date || user || transaction type || Amount
I hope this table has a primary key, and you just omitted mentioning it
because this particular case doesn't use it.
> I want to get one particular transaction type as a percentage of the
> total transactions : for example, a list of the % amount that Debit
> transactions have occurred for a user for a day, with respect to all
> transactions that the user has done that day, so :
>
> Debits Jim performed on day 1 are 50% of all transactions he performed
> Debits Jim performed on day 2 are 55% of all transactions he performed
[snip]
> Can anyone suggest a way of doing this without the need for these
> temporary tables???
Untested:
select date, user,
coalesce(
sum(case transaction_type when 'debit' then amount else 0 end)
, 0
) / sum(amount) as perc_debit
from the_table
group by date, user
Navigation:
[Reply to this message]
|