Subject | Re: group by or distinct |
---|---|
Author | kaczy27 |
Post date | 2004-09-02T08:53:27Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@m...>
wrote:
wrote:
> > hello,different?? what do I miss? what is the difference?
> >
> > 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?
> AlanCUIN Kaczy