sql去重，实现多个字段的去重以及可随意返回不同字段值
程序员文章站
2022-06-11 17:09:33
...
select imei,usim,created_at from record WHERE id IN(SELECT id from record GROUP BY imei,usim) ORDER BY created_at DESC limit 0,10