/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 vote341 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote379 views1 answer
Query by column for substring sql
SQL
1 vote370 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote349 views1 answer
Sql row number in result set
SQL
10 votes361 views4 answers
Mysql one week ago
SQL
0 vote352 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
0 vote372 views1 answer
Top frequency in sql server
SQL
-1 vote377 views1 answer
Default username and password for oracle 11g
SQL
0 vote409 views1 answer
Python mysql check if database exists
SQL
0 vote398 views1 answer
Oracle concat datetime
SQL

Share