/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 vote230 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote240 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote219 views1 answer
Select from one table where not on the other
SQL
0 vote230 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote240 views1 answer
Alter table add check constraint oracle
SQL
0 vote219 views1 answer
How to select only id where is not in column mysql
SQL
11 votes213 views2 answers
Having keyword sql
SQL
6 votes233 views1 answer
Oracle trigger after logon on schema
SQL
0 vote253 views1 answer
Implode in sql query
SQL
11 votes232 views5 answers
How to install sqlite3 python
SQL

Share