divide the value of a column by another column

Question

I want to divide a value of a column by the value of another column and display the result as separate column

ex:

project name             total-percent        no.of screen
------------            --------------        -------------
pro-1                     150                     5
pro-2                      50                     3

now i want to divide total-percent by no.of screen and display the result in another column

Mahmoud Gamal · Accepted Answer · 2011-11-25T13:40:33.627

25

Select total_percent / no_of_scren as 'result' From yourTableName

edited Nov 25 '11 at 13:40

answered Nov 24 '11 at 12:34

Mahmoud Gamal

78,257
17
139
164

Indeed it is just a matter of dividing ... ;) – BuZz Nov 24 '11 at 12:37
1

Are there issues of integer division? – Climbs_lika_Spyder Jun 04 '15 at 20:07
@Climbs_lika_Spyder - What do you mean? if you mean there are some fractions discarded from dividing integers, yes there are and the OP should handle this, and there is also the divide by zero issue and he should handle this by checking first before dividing. – Mahmoud Gamal Jun 05 '15 at 05:51
13

I found my issue. I needed to `CAST( x as FLOAT)/y` to avoid the `0` result. – Climbs_lika_Spyder Jun 05 '15 at 15:38

divide the value of a column by another column

1 Answers1

Linked