create cursor mycursor(gamename c(5),quantity n(10,2)) insert into mycursor values ('fdss',1) insert into mycursor values ('ghrr',1) insert into mycursor values ('gersd',1) insert into mycursor values ('few',2) select avg(quantity) from mycursor>Help please!
create cursor mycursor(gamename c(5),quantity i) >insert into mycursor values ('fdss',1) >insert into mycursor values ('ghrr',1) >insert into mycursor values ('gersd',1) >insert into mycursor values ('few',2) >select avg(quantity) from mycursor>I get integer(1) not 1.25, why?