//删除表中重复数据
select distinct * from Table_1
//删除表中字段为空的数据
delete from address where _tel is null
//sql获取前30天的日期
select dateadd(day,-30,getdate())