On Fri, 9 Apr 2004 08:31:41 +0100, Tomasz Chilinski wrote
> select floor(time/86400) as date, taxvalue, SUM(value) as total from
> cash where type=3 group by date, taxvalue order by date,taxvalue
> DESC;
Coś takiego przeleci w postgresie i sqllite:
select floor(time/86400) as date, sum(if(cash.taxvalue=22.00,value,0)) as
tax22, sum(if(cash.taxvalue=7.00,value,0)) as tax7,
sum(if(cash.taxvalue=0.00,value,0)) as tax0,
sum(if(cash.taxvalue=NULL,value,0)) as taxfree from cash where type=3 group
by date order by date;
???
Pozdrawiam
Tomasz Chiliński
