What is difference between group by and distinct function

Question

Accepted Answer

Group by is used to group rows based on a column, while distinct function is used to remove duplicate values from a column.

Group by is used with aggregate functions like count, sum, avg, etc.
Distinct function is used to retrieve unique values from a column.
Group by can be used with multiple columns to create groups based on multiple criteria.
Distinct function can be used with multiple columns to retrieve unique combinations of values.
Group by is often used in conjunction with the having clause to filter groups based on conditions.

Accepted Answer

Distinct removes duplicate rows while group by doesn't there will be follow up question also, classic salary question where get records of a particular employee where date between

What is difference between group by and distinct function

Popular interview questions of Senior PHP Developer

Top HR questions asked in Nirvasa Healthcare Senior PHP Developer