If knowledge is power, then sharing knowledge is ultimate powertrip
You are here: Home >> Tag Archives: distinct

Tag Archives: distinct

Feed Subscription

Difference between distinct and group by in mysql

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