/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 vote187 views1 answer
Authentication in sql server
SQL
3 votes197 views3 answers
Mysql declare variable
SQL
0 vote189 views1 answer
Data structures in sql
SQL
4 votes198 views1 answer
Oracle error line
SQL
0 vote211 views1 answer
How to alter length character varying postgres
SQL
0 vote186 views1 answer
Insert or update cassandra
SQL
0 vote197 views1 answer
Get date from timestamp in mysql
SQL
0 vote142 views1 answer
Ms sql print more than 1 variable
SQL
0 vote188 views1 answer
Case insensitive sql
SQL
0 vote211 views1 answer
SQLServerException.makeFromDatabaseError
SQL

Share