'Getting duplicate rows while using DISTINCT in mysql database

SELECT distinct user_id as "User Id",
       date(date_created) AS "time",
FROM user
WHERE date_created BETWEEN FROM_UNIXTIME(1630141526) AND FROM_UNIXTIME(1646039126)
  AND status = 'CONFIRMED'
  AND organization_uuid = '// organization id';

This is my sql query I use the distinct for removing distinct user id but my query return duplicates user id.

I am getting user id = 139555 two times even i use distinct keyword

enter image description here

mysql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions