/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

2 votes238 views1 answer
Sql get the name of user pc
SQL
11 votes186 views2 answers
Having clause
SQL
0 vote203 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote229 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
-1 vote214 views1 answer
Default username and password for oracle 11g
SQL
3 votes260 views2 answers
Update part of a string in mysql
SQL
1 vote194 views1 answer
Delete mysql from mac
SQL
0 vote270 views1 answer
Postgres select from values
SQL
1 vote199 views1 answer
Drop table if exists oracle
SQL
4 votes302 views1 answer
Select first and last row sql
SQL

Share