SQL 平均数统计
sql下求列的平均数的语句
代码如下:
SELECT CAST(SUM(score_comments_) / COUNT(*) AS
decimal) AS score
FROM Comments_Toysgogo_
WHERE (aboutid_comments_ = 81) AND (table_comments_ = 'product')
sql下求列的平均数的语句
代码如下:
SELECT CAST(SUM(score_comments_) / COUNT(*) AS decimal) AS score
FROM Comments_Toysgogo_
WHERE (aboutid_comments_ = 81) AND (table_comments_ = 'product')
