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
sql去重,实现多个字段的去重以及可随意返回不同字段值
最新推荐文章于 2024-04-30 15:35:14 发布
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