How to divide two columns

Question

I tried to divide two columns from joined tables but the result  value of column relative duration  is always 0  The query is the following       SELECT t1  user 1         t1  user 2         t1  total duration          t1 total duration t2  total events duration   AS relative duration   FROM  CDRs   dbo   aggregate monthly events  AS t1 INNER JOIN  CDRs   dbo   user events monthly stats  AS t2 ON t1  user 1    t2  user 1    Does anyone know what could be wrong in the query above and how to fix it in order to divide column total duration from table t1 with column total events duration from table t2   BTW I tried to replace division with subtraction      with  -   and in that case the column relative duration is not 0

User · Accepted Answer

Presumably  those columns are integer columns - which will be the reason as the result of the calculation will be of the same type   e g  if you do this   SELECT 1   2   you will get 0  which is obviously not the real answer  So  convert the values to e g  decimal and do the calculation based on that datatype instead   e g    SELECT CAST 1 AS DECIMAL    2   gives 0 500000

[sql] How to divide two columns?

Examples related to sql