SQL SERVER – Difference between DISTINCT and GROUP BY – Distinct vs Group By | Journey to SQL Authority with Pinal Dave

This question is asked many times to me. What is difference between DISTINCT and GROUP BY? A DISTINCT and GROUP BY usually generate the same query plan, so performance should be the same across both query constructs. GROUP BY should be used to apply aggregate operators to each group. If all you need is to… Continue Reading...

Source: SQL SERVER – Difference between DISTINCT and GROUP BY – Distinct vs Group By | Journey to SQL Authority with Pinal Dave