我需要对年份进行分组,并用每年的平均值选择最后五年,这样我就有了平均值和年产量
SELECT AP, yr
FROM (
SELECT Year AS yr, AVG( "tbltest.AskingPrice" ) AS AP
FROM tbltest
GROUP BY `yr` DESC
LIMIT 5
)sub
GROUP BY `yr` ASC
SELECT sub.yr, sub.AP
FROM (
SELECT Year AS yr, AVG(AskingPrice) AS AP
FROM tbltest
GROUP BY yr
ORDER BY yr DESC
LIMIT 0,5
) sub
ORDER BY sub.yr ASC
我认为您的子查询符合您的要求:
SELECT Year AS yr, AVG( "tbltest.AskingPrice" ) AS AP
FROM tbltest
GROUP BY `yr`
ORDER BY Year DESC
LIMIT 5;
为了与标准SQL保持一致,我只是将desc
移到了order by
。