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.
Possibly related:
- An alternative to DISTINCT
- Oracle OpenWorld 2006 Flickr Group
- Oracle Bloggers Frappr Group
- ATTENTION bloggers
- The Value of Oracle Users Groups
Tagged distinct, group, sql | Post a Comment


















Home > About This Post
This entry was posted by Eddie Awad on Monday, June 27th, 2005, at 12:29 pm, and was filed in Oracle.
Subscribe to the
RSS 2.0 feed for all comments to this post.
Post a Comment