Subject | group by or distinct |
---|---|
Author | kaczy27 |
Post date | 2004-09-02T08:30:26Z |
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
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