SELECT a.* from visit as a where not exists (select 1 from visit as b where b.name = a.name and (b.id < a.id))
mysql实现name姓名多个相同的数据只取一条
最新推荐文章于 2023-01-18 14:55:32 发布
SELECT a.* from visit as a where not exists (select 1 from visit as b where b.name = a.name and (b.id < a.id))