dm达梦数据库表中重复记录数sql语句的查询及删除操作 |
您所在的位置:网站首页 › 数据库中如何查询重复字段的数据 › dm达梦数据库表中重复记录数sql语句的查询及删除操作 |
1、字段列对应重复记录数据的查询sql,简单就是取出某个字段多个重复值分组数量 select supplier_name ,count(*) from MO_FROM_SYS.SUPPLIER group by order_code having count(*) > 1; 2、删除表字段中重复记录数的sql语句(ID为当前表的主键值,usage_category_name为具体字段) delete from MO_FORM_V8.UNS_HOUSE_GOODS where usage_category_name in ( select usage_category_name from MO_FORM_V8.UNS_HOUSE_GOODS group by usage_category_name having count(*) > 1 ) and id not in ( select min(id) from MO_FORM_V8.UNS_HOUSE_GOODS group by usage_category_name); |
今日新闻 |
推荐新闻 |
CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |