You can use a case clause update tbl1 set col1 = (case when col1 <= 3 then 1 else (col1 - 3) end);. As @RDFozz described : With the OP's listed code, ...
確定! 回上一頁