CASE Statements in A SQL UPDATE Query
UPDATE [account] SET balance = ( CASE WHEN ((balance - 10.00) < 0) THEN 0 ELSE (balance - 10.00) END ) WHERE condition
ORACL, DBA, PL/SQL, DWH,LINUX, SQL SERVER, IT SECURITY, BI, ANALYTICS