将AVG(价格)添加到mySQL查询中

Adding AVG(Price) into a mySQL query?

本文关键字：mySQL 查询添加 AVG 价格 | 更新日期: 2023-09-27

$query = "SELECT * FROM used ".$conditionString." ORDER BY id DESC LIMIT $offset, $rec_limit";

现在我想知道返回行的平均价格

AVG(Price) AS PriceAverage

$query = "SELECT *,AVG(Price) FROM used ".$conditionString." ORDER BY id DESC 
GROUP BY id WITH ROLLUP 
LIMIT $offset, $rec_limit";

演示:http://sqlfiddle.com/# !2/4938f/1/0