/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

0 vote355 views1 answer
Kill a pid redshift
SQL
8 votes341 views1 answer
Insert a select statement into a table
SQL
0 vote368 views1 answer
Sql string contains case sensitive
SQL
0 vote341 views2 answers
How to start postgresql laravel
SQL
0 vote372 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote341 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
1 vote417 views1 answer
How to put value in variable mysql
SQL
0 vote362 views1 answer
Sql server select record with max id
SQL
0 vote354 views1 answer
Print intervals of 15 minutes in sql query
SQL
0 vote291 views1 answer
Oracle last user logon
SQL

Share