场景:
提示:MySQL去重(DISTINCT满足不了,高版本groupBy(this is incompatible with sql_mode=only_full_group_by))解决方法
例如:多表查询很多列数据相同,只有一列数据不同 DISTINCT去重失败
问题描述:
1: 使用DISTINCT关键字
按照id去重,因为reviewTime时间不相同,所以无法使用distinct去重
SELECT
DISTINCT
ypr.id,
ypr.logic_uuid,
ypr.product_research_name,
ypr.pr_sku_desc AS skuDesc,
ypr.category_id,
ypr.supplier_type,
ypr.CREATED_TIME AS createTime,
yc.UPDATED_TIME AS reviewTime,
ypr.user_id,
u.user_name AS createName
FROM
product_research ypr
LEFT JOIN sys_dept d ON d.dept_id = ypr.dept_id
LEFT JOIN sys_user u ON u.user_id = ypr.user_id
LEFT JOIN circulation yc ON yc.relation_id = ypr.id
WHERE
ypr.IS_DELETE = '0'
2:使用groupBy排序
解决方案:
结合mysql函数groupBy