Answers for "sql divide by zero error"

divide by zero error in sql

#Dividing a/b

SELECT a / NULLIF(b, 0) 
FROM t

Posted by: Guest on June-16-2021

replace divide by zero error with 0 in sql

#Replace the result of divide by zero with 0

SELECT COALESCE(dividend / NULLIF(divisor,0), 0) 
FROM sometable

Posted by: Guest on June-16-2021

Code answers related to "sql divide by zero error"