Subject Re: group by or distinct
Author kaczy27
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
> > hello,
> >
> > what is faster in such case:
> >
> > select
> > field1, field2, field3
> > from
> > table1
> > group by
> > field1, field2, field3;
> >
> > or
> >
> > select distinct
> > field1, field2, field3
> > from
> > table1;
> >
> > CUIN Kaczy
>
> different results for each - which one do you want?
different?? what do I miss? what is the difference?

> Alan
CUIN Kaczy