/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 vote205 views1 answer
Psql select * from table
SQL
10 votes206 views1 answer
Query to find object dependencies in oracle
SQL
0 vote229 views1 answer
Mysql edit trigger
SQL
0 vote209 views1 answer
Sql server check whether column has same equal values
SQL
1 vote207 views2 answers
Postgres cast as decimal
SQL
0 vote197 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote251 views1 answer
Generate a random otp in sql server
SQL
0 vote205 views1 answer
Vowels in sql
SQL
0 vote211 views1 answer
Sql select sum group by id laravel join
SQL
-1 vote203 views1 answer
Insert results of a stored procedure into a temporary table
SQL

Share