/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 vote292 views1 answer
Postgresql subquery
SQL
0 vote351 views1 answer
Add new column in sql with foreign key
SQL
7 votes320 views6 answers
Group_concat in mysql
SQL
0 vote303 views2 answers
2nd max salary query in sql
SQL
0 vote304 views2 answers
Postgresql get last day of month
SQL
0 vote312 views1 answer
Sauvegarde complète my sql
SQL
2 votes309 views1 answer
Merge two columns in sql oracle
SQL
3 votes322 views1 answer
Postgresql db owner change
SQL
0 vote309 views1 answer
Mysql two joins
SQL
0 vote314 views1 answer
Call rest api from postgresql
SQL

Share