/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

20 votes274 views2 answers
Counting in sql
SQL
2 votes268 views1 answer
Anonymous block plsql
SQL
0 vote278 views2 answers
Select index table oracle
SQL
1 vote268 views1 answer
Display total number of tables in mysql
SQL
0 vote278 views1 answer
Sequelize postgresql schema
SQL
1 vote292 views3 answers
What is union in sql
SQL
0 vote284 views1 answer
How to get data from 2 database
SQL
11 votes298 views3 answers
Sql_mode=only_full_group_by
SQL
11 votes280 views2 answers
Turn off safe mode mysql
SQL
1 vote296 views2 answers
Postgres select from last 3 months
SQL

Share