Question: what is the difference between group by and distinct in mysql?
Answer: 3 Answers. Well group by and distinct has its own use. Distinct is used to filter unique records out of the records that satisfy the query criteria. Group by clause is used to group the data upon which the aggregate functions are fired and the output is returned based on the columns in the group by clause.