why distinct in this case doesn't work same as group by

Question

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

Answer 1

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

Answer 2

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.

Answer 3

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

why distinct in this case doesn't work same as group by

Submit an answer

related questions