/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 vote186 views2 answers
How to prevent sql injection in java
SQL
0 vote139 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote139 views2 answers
Mysql on update current_timestamp
SQL
0 vote159 views1 answer
Mysql delete from where like
SQL
0 vote186 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
13 votes291 views4 answers
Sql joining 3 tables
SQL
0 vote152 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote162 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote145 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
1 vote151 views2 answers
Sql server concat string and int
SQL

Share