SQL查询——我可以不这样做吗?

update TABLE set A = (
SELECT
    CASE
        WHEN B - C >= A  THEN A
        WHEN B - C <  A THEN B - C
    END AS A
from 
TABLE )
update TABLE set A = (
SELECT
    CASE