Question: what is difference between distinct and group by in mysql?
Answer: SELECT DISTINCT vs GROUP BY in MySQL? SELECT DISTINCT can be used to give distinct values. Use it to remove duplicate records and it can be used with aggregate function as well. ... Select group by can be used to get data from different columns and group into one or more column.