1、查找表中重复记录,重复记录是根据单个字段(description )来判断
select * from device where description in (select description from device group by description having count(description) > 1) and deviceid like ‘%DATACOLLECTOR_188/ENERGY/YDWL/1.0/%’
查询字段名称相同的sql
最新推荐文章于 2024-07-19 03:29:12 发布