How to divie int column in sql
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