Hi Martin, Just want to know when I use DISTINCT instead of GROUP BY clause, I got 24 row which has to be 20 as we use GROUP BY but why this doesn't work here Code I used: SELECT distinct m.emp_no, m.dept_no, d.dept_name FROM departments_dup d INNER JOIN dept_manager_dup m ON d.dept_no = m.dept_no -- GROUP BY emp_no ORDER BY dept_no; Thanx again for answering

Hi Mayank! Thanks for reaching out. Could you please provide further explanation to your question? Are you asking about the differences between the GROUP BY clause and the DISTINCT keyword? Thank you. Looking forward to your answer. Best, Tsvetelin

Actually yes also the code provided above I use both group by and distinct where group by works perfectly and provide me unique rows while distinct doesn't which i supposed to do soo.

Hi Mayank! Thanks for reaching out. The GROUP BY clause lets you use aggregate functions, like AVG(), MAX(), MIN(), SUM(), and COUNT(). On the other hand DISTINCT just removes duplicates. Hope this helps. Best, Tsvetelin