/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

0 vote317 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
0 vote319 views1 answer
Turnicate in mysql
SQL
0 vote313 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
7 votes330 views6 answers
Group_concat in mysql
SQL
0 vote336 views2 answers
Soql last year
SQL
0 vote320 views1 answer
Sql recherche nom prenom
SQL
0 vote279 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote339 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
3 votes324 views3 answers
Concatenation in sql
SQL
2 votes295 views1 answer
Oracle sql drop column if exists
SQL

Share