• If the requirement is to remove duplicate rows, use DISTINCT

    If the requirement is to produce aggregates with grouping, use GROUP BY

    Seeing Group By with no aggregates suggests that someone read the myth that group by is faster/better than DISTINCT and didn't do any tests.

    Specify the query in the simplest, most obvious way, if after testing performance is inadequate then consider alternate query forms and test them. If they're faster great, if not, go back to the simple form.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass