/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

2 votes167 views2 answers
Sqlalchemy filter or
SQL
0 vote162 views1 answer
Sql random decimal
SQL
10 votes187 views2 answers
Mysql remove only_full_group_by permanently
SQL
11 votes193 views5 answers
Laravel db facade
SQL
9 votes187 views6 answers
Sql add column with default value
SQL
0 vote189 views2 answers
Jsonb
SQL
0 vote175 views1 answer
Mysql to get column name in database
SQL
-1 vote165 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote201 views1 answer
Mysql config slave
SQL
2 votes250 views1 answer
Sql missing records from another table
SQL

Share