删除数据的sql语句 truncate table --删除单个站点的相关数据【只删除数据,不删除基本信息】 --总表 DELETE FROM [In_Port_Log] where Hardware_Id='' DELETE FROM [In_Port_LogError] where Hardware_Id='' --降雨 DELETE FROM......
查询和删除表中重复数据 sql 语句 (一) 1、查询表中重复数据。select * from people where peopleId in (select peopleId from count(peopleId) > 1) people group by peopleId having 2、删除表中多余的重复记录,重复记录是根据......