SQL 平均數(shù)統(tǒng)計

sql下求列的平均數(shù)的語句

代碼如下:
select CAST(SUM(score_comments_) / COUNT(*) AS decimal) AS score
FROM Comments_Toysgogo_
WHERE (aboutid_comments_ = 81) AND (table_comments_ = ‘product’)

? 版權(quán)聲明
THE END
喜歡就支持一下吧
點贊10 分享