/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

1 vote217 views1 answer
Oracle finding duplicate records
SQL
0 vote220 views1 answer
Where field is null sql knex
SQL
11 votes219 views1 answer
Get ddl materialized view oracle
SQL
0 vote286 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote206 views2 answers
Mysql spring boot application.properties
SQL
1 vote234 views1 answer
Postgres left join
SQL
0 vote221 views1 answer
Complete date is 1 year or not sql server
SQL
14 votes217 views3 answers
SQL trim
SQL
0 vote216 views1 answer
Laravel eloquent get generated sql
SQL
0 vote214 views1 answer
Opening xampp mysql in cmd ubuntu
SQL

Share