--- In firebird-support@yahoogroups.com, "Dmitry Yemanov"
<dimitr@u...> wrote:

>
> "arhampshire" <arhampshire@y...> wrote:
> >
> > select A, min(B), max(B), count(*)
> > from myTable
> > where A = 10
> > group by A;
>
> Do you use some query generating tool or is it just a bad example?

I see no

> reason to use a GROUP BY clause here.
>
> > Are there any tips, or pointers to improve performance of

queries?

>
> Could you please show a plan for this query?
>
>
> Dmitry
>

I'd be very interested to know how you can write an aggregate query
without the group by clause.