select * from kucun t1 where not exists (select 1 from kucun t2 where t2.name=t1.name and t2.bianhao<t1.bianhao)
SQl不重复的所有数据(重复的只显示一条)
最新推荐文章于 2024-07-04 16:29:03 发布
select * from kucun t1 where not exists (select 1 from kucun t2 where t2.name=t1.name and t2.bianhao<t1.bianhao)