SELECT * FROM
tableName
WHERE
id IN ( SELECT max(id) FROM tableName GROUP BY column1, column2,column3);
SQL指定去重某几个字段并返回所有值
最新推荐文章于 2024-09-05 10:10:33 发布
SELECT * FROM
tableName
WHERE
id IN ( SELECT max(id) FROM tableName GROUP BY column1, column2,column3);