Is there any difference between GROUP BY and DISTINCT

by

MusiGenesis‘ response is functionally the correct one with regard to your question as stated; the SQL Server is smart enough to realize that if you are using “Group By” and not using any aggregate functions, then what you actually mean is “Distinct” – and therefore it generates an execution plan as if you’d simply used “Distinct.”

However, I think it’s important to note Hank‘s response as well – cavalier treatment of “Group By” and “Distinct” could lead to some pernicious gotchas down the line if you’re not careful. It’s not entirely correct to say that this is “not a question about aggregates” because you’re asking about the functional difference between two SQL query keywords, one of which is meant to be used with aggregates and one of which is not.

A hammer can work to drive in a screw sometimes, but if you’ve got a screwdriver handy, why bother?

(for the purposes of this analogy, Hammer : Screwdriver :: GroupBy : Distinct and screw => get list of unique values in a table column)

More Related Contents:

  1. Group by minimum value in one field while selecting distinct rows
  2. Huge performance difference when using GROUP BY vs DISTINCT
  3. Select first row in each GROUP BY group?
  4. How do I (or can I) SELECT DISTINCT on multiple columns?
  5. Using group by on multiple columns
  6. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  7. GROUP BY with MAX(DATE) [duplicate]
  8. must appear in the GROUP BY clause or be used in an aggregate function
  9. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  10. How to group time by hour or by 10 minutes
  11. Concat groups in SQL Server [duplicate]
  12. SQL query for finding records where count > 1
  13. GROUP BY + CASE statement
  14. SQL to find the number of distinct values in a column
  15. sql query distinct with Row_Number
  16. SQL GROUP BY CASE statement with aggregate function
  17. Mysql: how to select groups having certain values?
  18. MySQL #1140 – Mixing of GROUP columns
  19. SQL Server Update Group by
  20. Selecting all corresponding fields using MAX and GROUP BY
  21. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  22. How can I group time by hour or by 10 minutes?
  23. SQL not a single-group group function
  24. Conditional SQL count
  25. SQL distinct for 2 fields in a database
  26. Select distinct from multiple fields using sql
  27. How to get list of values in GROUP_BY clause?
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. SQL query with distinct and sum
  30. How to group by a Calculated Field

Leave a Comment