Dharmesh Sharma

Dharmesh Sharma

  • NA
  • 905
  • 927.1k

How to divie int column in sql

Dec 31 2010 7:48 AM
hi

i n my project i have database in one table i have 31 column int type

now i m add thies column and divide by 60

this is my query
 SELECT (([1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10]+[11]+[12]+[13]+[14]+[15]+[16]+[17]+[18]+[19]+[20]+[21]+[23]+[24]+[25]+[26]+[27]+[28]+[29]+[30]+[31])/60) From  tablexyz

but i m get 0 output

i need value in 0.00 form
i mean

data is

Fields       1   2    3    4     5    6     7........31

data        10  20    .....................................


now i add these and divide by 60

i want to  get full result in decimal format


plz help me



Answers (1)