鍦ㄥ嚑鍗冩潯璁板綍閲?瀛樺湪鐫?浜涚浉鍚岀殑璁板綍,濡備綍鑳界敤SQL璇?彞,鍒犻櫎鎺夐噸澶嶇殑鍛?br>1銆佹煡鎵捐〃涓??浣欑殑閲嶅?璁板綍锛岄噸澶嶈?褰曟槸鏍规嵁鍗曚釜瀛楁?锛坧eopleId锛夋潵鍒ゆ柇
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)
2銆佸垹闄よ〃涓??浣欑殑閲嶅?璁板綍锛岄噸澶嶈?褰曟槸鏍规嵁鍗曚釜瀛楁?锛坧eopleId锛夋潵鍒ゆ柇锛屽彧鐣欐湁rowid鏈?灏忕殑璁板綍
delete from people
where聽聽 peopleName in (select peopleName聽聽聽 from people group by peopleName聽聽聽聽聽 having count(peopleName) > 1)
and聽聽 peopleId not in (select min(peopleId) from people group by peopleName聽聽聽聽 having count(peopleName)>1)
3銆佹煡鎵捐〃涓??浣欑殑閲嶅?璁板綍锛堝?涓?瓧娈碉級
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
4銆佸垹闄よ〃涓??浣欑殑閲嶅?璁板綍锛堝?涓?瓧娈碉級锛屽彧鐣欐湁rowid鏈?灏忕殑璁板綍
delete from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)
5銆佹煡鎵捐〃涓??浣欑殑閲嶅?璁板綍锛堝?涓?瓧娈碉級锛屼笉鍖呭惈rowid鏈?灏忕殑璁板綍
select * from vitae a
where (a.peopleId,a.seq) in (select peopleId,seq from vitae group by peopleId,seq having count(*) > 1)
and rowid not in (select min(rowid) from vitae group by peopleId,seq having count(*)>1)聽聽聽
6.娑堥櫎涓?涓?瓧娈电殑宸﹁竟鐨勭?涓?浣嶏細
update tableName set [Title]=Right([Title],(len([Title])-1)) where Title like '鏉?'
7.娑堥櫎涓?涓?瓧娈电殑鍙宠竟鐨勭?涓?浣嶏細
update tableName set [Title]=left([Title],(len([Title])-1)) where Title like '%鏉?
8.鍋囧垹闄よ〃涓??浣欑殑閲嶅?璁板綍锛堝?涓?瓧娈碉級锛屼笉鍖呭惈rowid鏈?灏忕殑璁板綍
update vitae set ispass=-1
where peopleId in (select peopleId from vitae group by peopleId
聽
select *from r_people_report_bak ppp where 1=1and length(ppp.reporting_period)<=6and ppp.organization_code || '_' ||to_char(to_date(ppp.reporting_period ,'YYYY-mm'),'yyyy') || '-' || to_char(to_date(ppp.reporting_period ,'YYYY-mm'),'mm')|| '_' || ppp.datilor_allin (select pp.organization_code || '_' || pp.aa || '_' || pp.datilor_all from (select p.people_id,p.organization_code,p.datilor_all,to_char(to_date(p.reporting_period ,'YYYY-mm'),'yyyy') || '-' || to_char(to_date(p.reporting_period ,'YYYY-mm'),'mm') aafrom r_people_report_bak p where p.reporting_period is not null ) ppgroup by pp.aa ,pp.organization_code,pp.datilor_allhaving count(1) > 1 )
聽
聽
聽