使用标准偏差使用mysql删除异常值

您可以诱使MySQL通过另一个子选择来做到这一点

DELETe FROM sv_condition_sw WHERe snow_mountain > (select * from (SELECt AVG(snow_mountain)+1.5*STDDEV(snow_mountain)      FROM sv_condition_sw      WHERe lud='2012-11-28'      AND res_id=769) x) AND lud='2012-11-28' AND res_id=769