If knowledge is power, then sharing knowledge is ultimate powertrip
Latest Updates
You are here: Home >> Tag Archives: group by

Tag Archives: group by

Feed Subscription

Difference between distinct and group by in mysql

distinctAndGroupBy

The difference between DISTINCT and GROUP BY in Mysql is that they 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 remove duplicates then use DISTINCT. If you are using sub-queries execution plan for that ... Read More »

Scroll To Top