/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 vote283 views2 answers
Postgres select from last 3 months
SQL
49 votes235 views6 answers
Get duplicate records in sql
SQL
0 vote169 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote169 views1 answer
Cartesian product sql
SQL
0 vote149 views2 answers
Sqlite unix timestamp
SQL
0 vote158 views1 answer
SQL Server modify_timestamp trigger
SQL
11 votes161 views1 answer
Creating tables in sql with python
SQL
0 vote152 views2 answers
Get all index postgres
SQL
0 vote154 views1 answer
Mysql uuid
SQL
0 vote163 views1 answer
Oracle list partitions
SQL

Share