|Subject||Re: [ib-support] Re: SQL: Number of entries per day|
Alan McDonald wrote:
>cause you need to group by all of themWill not group in SELECT but should in plain view and th?n group.
> -----Original Message-----
> From: Andrew Guts [mailto:andr@...]
> Sent: Monday, 16 September 2002 23:07
> To: email@example.com
> Subject: Re: [ib-support] Re: SQL: Number of entries per day
> How about one CAST(ts as date) instead of 3 EXTRACTs there?
> Arno Brinkman wrote: