On 11:33 am 07/21/08 "A B" <gentosaker@xxxxxxxxx> wrote: > and I want it to be > A 1 > B 3 > C 44 The slow way select distinct field1, field2 from sometable. The faster way select field1,fields2 from sometable group by field1, field2. Distinct should in theory be the same speed, but on several tests I have done group by was faster. I posted a message to the list and there were some explanations why group by was faster.. Hopefully someday they should perform just as efficiently.
