谁能帮忙改一个UPDATE语句。。。最后10分了，抱歉。

Question

UPDATE BD_REQUEST_DATA_PU
SET TOTAL_REQUEST = case(CURRENT_REQUEST + QTY_ON_STOCK, when 0 then 0 else CURRENT_REQUEST + QTY_ON_STOCK end)

Answer 1

update BD_REQUEST_DATA_PU
set TOTAL_REQUEST = case 
                        when CURRENT_REQUEST > 0 
                          then CURRENT_REQUEST + QTY_ON_STOCK
                        else 0 
                    end

Answer 2

试试UPDATE BD_REQUEST_DATA_PU
SET TOTAL_REQUEST = 
(Case When CURRENT_REQUEST > 0 Then CURRENT_REQUEST + QTY_ON_STOCK When CURRENT_REQUEST < 1 Then 0 End)

Answer 3

update BD_REQUEST_DATA_PU
set TOTAL_REQUEST =
(case when CURRENT_REQUEST>0 then (CURRENT_REQUEST + QTY_ON_STOCK) else 0 end)

Answer 4

update BD_REQUEST_DATA_PU
set TOTAL_REQUEST = case 
                        when CURRENT_REQUEST > 0 
                          then 
                             case 
                               when CURRENT_REQUEST + QTY_ON_STOCK <0
                                 then 0
                               else CURRENT_REQUEST + QTY_ON_STOCK
                             end
                        else CURRENT_REQUEST 
                    end