/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 votes259 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote268 views1 answer
Postgresql on conflict pair
SQL
2 votes318 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
3 votes262 views2 answers
Truncate all tables
SQL
1 vote262 views1 answer
Sql server epoch to datetime
SQL
92 votes443 views6 answers
Substring
SQL
0 vote258 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote266 views1 answer
Oracle previous year
SQL
0 vote268 views1 answer
Drop database using terminal postgres
SQL
0 vote264 views1 answer
Oracle select partition
SQL

Share