/SQL/Divide by zero error in sql

Divide by zero error in sql

Divide by zero error in sql

#Dividing a/b

SELECT a / NULLIF(b, 0) 
FROM t

1

Source: stackoverflow.com

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

0

Source: stackoverflow.com

Divide by zero error in sql

SELECT club_id, 
		males, 
        females, 
        males/NULLIF(females, 0) AS ratio
  FROM school_clubs;

0

Source: stackoverflow.com

Similar codes

1 vote187 views2 answers
Datetrunc hour snowflake
SQL
0 vote195 views1 answer
Insert into select with group by
SQL
0 vote179 views1 answer
Date datatype in livesql
SQL
0 vote183 views1 answer
Mariadb number format
SQL
1 vote199 views1 answer
Postgres regex remove special characters
SQL
5 votes236 views2 answers
Mysql where in array
SQL
0 vote281 views3 answers
CONTACT FORM SQL
SQL
6 votes232 views1 answer
Identify primary key in oracle table
SQL
0 vote224 views2 answers
Php convert dbf to mysql
SQL
0 vote195 views1 answer
Modifier une valeur sql
SQL

Share