站长统计导航窗口,湖南建筑人才网招聘,广州装修公司排名,电商网站的宣传推广思路先查询出满足某种条件的数据的最小ID#xff0c;然后删除最小ID以外的数据就实现了去重实例查询最小ID的重复数据select * from oms_relation_model ormwhere orm.fd_id(select min(t.fd_id) from oms_relation_model twhere orm.fd_ekp_idt.fd_ekp_id and orm.fd_ekp_idt…思路先查询出满足某种条件的数据的最小ID然后删除最小ID以外的数据就实现了去重实例查询最小ID的重复数据select * from oms_relation_model ormwhere orm.fd_id(select min(t.fd_id) from oms_relation_model twhere orm.fd_ekp_idt.fd_ekp_id and orm.fd_ekp_idt.fd_ekp_id);删除操作delete from oms_relation_model swhere s.fd_id not in (select orm.fd_id from oms_relation_model ormwhere orm.fd_id(select min(t.fd_id) from oms_relation_model twhere orm.fd_ekp_idt.fd_ekp_id and orm.fd_ekp_idt.fd_ekp_id));HQL/*** 不重复的id列表** return*/private List getUniqueIds() {Session session getBaseDao().getHibernateSession();String sql select fdId from OmsRelationModel orm where orm.fdId in (select min(fdId) from OmsRelationModel t where orm.fdEkpIdt.fdEkpId and orm.fdAppPkIdt.fdAppPkId);Query query session.createQuery(sql);List result query.list();logger.info(查询重复数据,list JSONUtils.valueToString(result));return result;}/*** 删除重复的** param idList*/private void delSame(List idList) {Session session getBaseDao().getHibernateSession();String sql delete from OmsRelationModel where fdId not in (:ids);Query query session.createQuery(sql);query.setParameterList(ids, idList);int result query.executeUpdate();logger.info(查询重复数据,list JSONUtils.valueToString(result));session.flush();session.clear();}
