/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 vote319 views1 answer
Oracle previous year
SQL
0 vote314 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
3 votes306 views1 answer
Fk in insert mysql
SQL
22 votes302 views3 answers
Join three tables sql
SQL
0 vote305 views1 answer
Sql case when exists in another table
SQL
2 votes308 views2 answers
How to check data type in sql server
SQL
1 vote302 views2 answers
Sql example query
SQL
-1 vote328 views2 answers
Installing mysql on centos 7
SQL
0 vote286 views1 answer
How to reset AI in sql
SQL
11 votes279 views1 answer
Reset identity sql server
SQL

Share