/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 vote250 views1 answer
Find how many tables in database sql query
SQL
-1 vote277 views1 answer
Difference berween database and data base management system
SQL
0 vote255 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
11 votes243 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
1 vote247 views1 answer
Sql server loop over query
SQL
0 vote250 views3 answers
How to assign custom id in mysql
SQL
1 vote225 views1 answer
Show table columns
SQL
0 vote228 views1 answer
Get cpu details sql
SQL
1 vote243 views1 answer
Psql search table
SQL
0 vote246 views1 answer
Report in database
SQL

Share