/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

6 votes175 views2 answers
WHERE value IS sql
SQL
0 vote148 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote138 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
1 vote130 views1 answer
Influxdb export to csv
SQL
0 vote151 views1 answer
How to get nth number in sql
SQL
4 votes144 views3 answers
Sqlite show columns
SQL
7 votes152 views1 answer
Sql pagination oracle
SQL
0 vote130 views1 answer
Remove binlog mysql
SQL
1 vote145 views1 answer
Mysql f# examples
SQL
3 votes139 views1 answer
Only join in sql
SQL

Share