时间戳

首页 > 解决方案 > DISTINCT 或 GROUP BY 不起作用。不确定是哪个

mysql - DISTINCT 或 GROUP BY 不起作用。不确定是哪个

问题描述

我在使用 DISTINCT 和 GROUP BY 的查询时遇到问题，但仍然收到相关行的重复行。G下面是查询：

SELECT DISTINCT ms.id AS ms_id, ms.identity, ms.timezone, ms.language,
 ms.country, ms.dst, ms.mobile, ms.voice, ms.email,  ms.firstname, ms.lastname, ms.gender, ms.address_1,
 ms.address_2, ms.city, ms.state, ms.zipcode, ms.dateofbirth,
  ms.custom_field_1, ms.custom_field_2, ms.custom_field_3, ms.custom_field_4,
 ms.custom_field_5, ms.carrier, ms.stamp AS ms_stamp,
  ss.id AS ss_id, ss.last_response_text, ss.stamp AS ss_stamp,
 c.id AS c_id, c.name, c.stamp AS c_stamp,
 c.messenger_account, c.keyword, c.community, ms.hash
 FROM tbl_messenger_subscriber_session ss
 JOIN tbl_messenger_subscriber ms ON ss.subscriber = ms.id
 LEFT JOIN tbl_messenger_subscriber_category c ON c.id = ss.subscriber_category
 WHERE ms.custom_field_1 = 'Middlesex' AND ss.subscriber_category IN ('23607','23634')
GROUP BY ms_id, c.messenger_account

输出看起来像这样

ms_id   | other columns
1636088 | xxxxxxxxxxxx
1636088 | xxxxxxxxxxxx
1636090 | xxxxxxxxxxxx
1636090 | xxxxxxxxxxxx
1636336 | xxxxxxxxxxxx
1636337 | xxxxxxxxxxxx

预期的输出看起来像这样

ms_id   | other columns
1636088 | xxxxxxxxxxxx
1636090 | xxxxxxxxxxxx
1636336 | xxxxxxxxxxxx
1636337 | xxxxxxxxxxxx

在查询 DISTINCT 和 GROUP BY 时我做错了什么，不能按预期工作吗？

标签： mysqlsqlgroup-bydistinct

解决方案

推荐阅读