> --- In firebird-support@yahoogroups.com, Tim Gahnström
> <tim.gahnstrom@i...> wrote:
> > > Try a:
> > > group by substring(name from 1 for 1)
> >
> > Thanks a lot! It solved the problem in a heartbeat.
> > I don't know how it is implemented but it certainly looks like the
> below will make two runs through the table, once in the select and
> once in the group by doing essentially the same thing.

> group by 1
>
> isn't enough?

It is indeed enough, I just hadn't heard about it before.

Thanks to both you and Helen for pointing it out!


Tim