/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

16 votes102 views1 answer
Mysql mediumint max value
SQL
2 votes117 views2 answers
Sql lag
SQL
0 vote109 views1 answer
Mysql docker image for macbook m1
SQL
0 vote108 views1 answer
Mariadb number format
SQL
1 vote104 views1 answer
Substr sql last character
SQL
0 vote69 views1 answer
Mysql workbench search all tables
SQL
0 vote106 views1 answer
Stored function in sql
SQL
0 vote114 views1 answer
Sql query to force the database to be drop
SQL
0 vote103 views1 answer
Delete * from where id = 1;
SQL
0 vote162 views1 answer
Scheduled mysql database backup in linux
SQL

Share