How about using "GROUP BY 1"?

Louis Kleiman
SSTMS, Inc.

----- Original Message -----
From: Boutwell, George
To: ib-support@yahoogroups.com
Sent: Tuesday, February 26, 2002 10:36 AM
Subject: Re: [ib-support] Converting from MSSQL


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/
>
>



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


[Non-text portions of this message have been removed]