34,590
社区成员
发帖
与我相关
我的任务
分享
delete t
from [tb] t
where data > (select avg(data) from tb where id=t.id)
;with cte as(
select *,[avg]=avg(data) over (partition by id) from tabname
)
delete from cte where data<=[avg]-10 or data>=[avg]+10;