select count(id) ,sum(cast(TK3_13 as decimal(10,2)))/10000 as zmj,
avg(cast(cast(zfj as float)/TK3_13 as decimal(10,2))) as aaa from table
where substring(date,0,8)='2010-10'
sql 统计
最新推荐文章于 2024-04-17 15:18:41 发布
select count(id) ,sum(cast(TK3_13 as decimal(10,2)))/10000 as zmj,
avg(cast(cast(zfj as float)/TK3_13 as decimal(10,2))) as aaa from table
where substring(date,0,8)='2010-10'