如果table使用別名,則應該:DELETE a from (select *,ROW_NUMBER() over(PARTITION by empid order by empid) as rn from b_emp ) a where ...
檢視全文»如果table使用別名,則應該:DELETE a from (select *,ROW_NUMBER() over(PARTITION by empid order by empid) as rn from b_emp ) a where ...
檢視全文»