ERR=Invalid token Column 1

I think it comes with firebird 1.5 that I do not have :))

How can I learn the version of Server in Delphi? or any external command?

Regards,

----- Original Message -----
From: "Daniel Rail" <daniel@...>
Newsgroups: egroups.ib-support
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, October 22, 2003 5:41 PM
Subject: Re: [firebird-support] SQL Extract problem - Monthly ordered Qty


> Hi,
>
> At October 22, 2003, 11:46, Tanz Anthrox wrote:
> > And, When I try to group it. not working
>
> > select
> > extract(month from order_date) as Exmonths , SUM(Qty_ordered) as QTY
> > from sales
> > group by Exmonths;
>
> Try:
>
> select
> extract(month from order_date) as Exmonths , SUM(Qty_ordered) as QTY
> from sales
> group by 1;
>
> The number 1 is to indicate column number 1 of the result set.
>
> --
> Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>