Re: FN-FORUM: Sql query help

date posted 13th January 2004 19:33

> it's very usefull expecialy if you need to show year by year (horizontal)
> and month by month (vertical) data.
>
> SELECT
> DATE_FORMAT( date_field, "%m" ) AS month,
> SUM(IF(DATE_FORMAT(date_field,"%Y")=="2002"),data_field,0)AS
year_2002,
> SUM(IF(DATE_FORMAT(date_field,"%Y")=="2003"),data_field,0)AS
year_2003,
> SUM(IF(DATE_FORMAT(date_field,"%Y")=="2004"),data_field,0)AS year_2004
> FROM
> table
> GROUP BY
> month

Aye that is quite pleasant.

Andy