I'm not positive it would work, but you could try:

select extract(month from sales_transaction.transaction_date) as monthtransactiondate, count(*)
from sales_transaction
Group By monthtransactiondate

HTH,
George

On 25 Feb 2002 at 23:26, didiergm wrote:

> Select extract (month from sales_transaction.transaction_date), count(*)
> from sales_transaction Group by extract(month from transaction_date)
>
> But I receive a complaint on line three any ideas ?
>
> Didier
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>