SQL 平均数统计
网络编程
SELECT CAST(SUM(score_comments_) / COUNT(*) AS decimal) AS score
FROM Comments_Toysgogo_
WHERE (aboutid_comments_ = 81) AND (table_comments_ = 'product')
编辑:一起学习网
标签:product,score,decimal,COUNT,SUM
SELECT CAST(SUM(score_comments_) / COUNT(*) AS decimal) AS score
FROM Comments_Toysgogo_
WHERE (aboutid_comments_ = 81) AND (table_comments_ = 'product')
编辑:一起学习网
标签:product,score,decimal,COUNT,SUM