/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 vote142 views1 answer
Find difference in dates sql
SQL
0 vote142 views1 answer
How to check common records in 2 table
SQL
1 vote136 views1 answer
Input in mysql
SQL
0 vote143 views1 answer
Intellij idea add mysql connector
SQL
0 vote88 views1 answer
How to connect sql server using ip address in c#
SQL
1 vote129 views2 answers
Grab part of a string sql
SQL
0 vote133 views2 answers
Create sequence if not exists postgres
SQL
2 votes176 views3 answers
Mysql kill
SQL
0 vote120 views2 answers
Mysql unique two columns
SQL
3 votes124 views1 answer
Postgresql if null then 0
SQL

Share