2. Tech
  3. Delete repetitive records in Table

Delete repetitive records in Table

xiaoxiao2021-03-05  33

Delete repetitive records in Table

Alter Table Admin Added Int IdenTies (1, 1) Go

Delete from admin where exissrs (select 1from admin) (select 1from admin) delete> admin.newid and admin.Uid = a.uid and admin.uname = a.uname andadmin.Upass a.upass andadmin.udep = a.UDEP) Go

Alter Table Admin Drop Column newidgo

转载请注明原文地址:https://www.9cbs.com/read-32499.html

9cbs

New Post(0)