/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 vote348 views1 answer
Oracle check table lock
SQL
0 vote337 views1 answer
How to add timestamp column in mysql
SQL
1 vote298 views1 answer
Mysql get last insert id
SQL
0 vote335 views1 answer
Selecting all columns from table sql database
SQL
3 votes636 views1 answer
Postgresql cast
SQL
5 votes336 views1 answer
JBDC
SQL
0 vote368 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote328 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
11 votes337 views1 answer
Get ddl materialized view oracle
SQL
0 vote363 views1 answer
Sql: extract day text from datetime value
SQL

Share