Subject RE: [firebird-support] group by or distinct
Author Alan McDonald
> 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?
Alan