/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 vote301 views2 answers
Sql last updated
SQL
2 votes287 views1 answer
Date conversion in mysql column
SQL
1 vote263 views1 answer
Oracle current sequence value
SQL
20 votes290 views3 answers
SQL query rename table
SQL
2 votes264 views2 answers
Sqlite_busy: database is locked
SQL
1 vote292 views1 answer
Sql how to duplicate a table
SQL
1 vote278 views2 answers
Mysql join two tables
SQL
1 vote319 views1 answer
Mysql view curren querys
SQL
18 votes245 views2 answers
How to get all the tables displayed in oracle
SQL
10 votes297 views1 answer
Oracle dba_dependencies
SQL

Share