SQL 删除当前日期前的所有数据

表名：main 字段名：outdate 格式(2014-5-10)
目标：删除数据库中main表outdate字段中所有当前日期之前的数据
DELETe * FROM main WHERe outdate <= Select Convert(char(10),getdate(),126);---这个错误
DELETE * FROM main WHERe outdate <= getdate();---这个也错误

把*号取了就对了

delete from 表名 where id not in(select top(10) id from 表名)

DELETe main WHERe outdate < GETDATE()

DELETe FROM main WHERe outdate <= getdate();