What is difference between group by and distinct function

AnswerBot
1y

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 ...read more

promptasparagus
author
1y

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

Help your peers!
Add answer anonymously...
Popular interview questions of Senior PHP Developer
Top HR questions asked in Nirvasa Healthcare Senior PHP Developer
>
Nirvasa Healthcare Senior PHP Developer Interview Questions
Stay ahead in your career. Get AmbitionBox app
Helping over 1 Crore job seekers every month in choosing their right fit company
65 L+
Reviews
4 L+
Interviews
4 Cr+
Salaries
1 Cr+
Users/Month
Contribute to help millions
Get AmbitionBox app