DISTINCT vs GROUP BY
Have you ever wondered about the difference between the use of DISTINCT and GROUP BY in your queries? I certainly have. Wonder no more. They are, for all intents and purposes, the same (as demonstrated by Tom).
Even though it requires more typing, but I prefer using GROUP BY (instead of DISTINCT when possible) as it is more explicit about what’s being unique or not in your result set.
Related articles:
- An alternative to DISTINCT
- Give Me One Minute And I’ll Tell You If You Are Liberal Or Conservative
- Oracle OpenWorld 2006 Flickr Group
