How to handle 'error: division by zero' in sql?

This error occurs when you're trying to divide a number by zero in a mathematical operation, which is undefined.

Example:

SELECT 100 / 0 AS result;

Solution:

SELECT 
    CASE WHEN divisor = 0 THEN NULL ELSE dividend / divisor END AS result
FROM (VALUES (100, 0)) AS t(dividend, divisor);

Use a CASE statement to handle zero divisor scenarios and avoid division by zero.