Differnt results for distinct and group by

[Shani Levy]

when I run:

select distinct column
from view

I get different results than:

select column
from view
group by column

how is it possible? (important to say that I'm filtering on specific dates in both queries)

here are my real queries:

select publisher_id
from vw_daily
where date between '2017-01-01' and '2017-01-18'
group by publisher_id;

select distinct publisher_id
from vw_daily
where date between '2017-01-01' and '2017-01-18';

[Mathieu Marquer (slasher-fun)]

Related to Amazon Redshift, not to this software called Redshift.