我的数据库名为test,我有一个名为HaveGoal的表。我对此提出疑问:
选择Rel.total
从(选择H.number、H.teamname、SUM(H.numberofgoals)作为总数
来自H.number,H.teamname的HaveGoal H组)作为版本
WHERE Rel.total =(从Rel中选择MAX(Rel.total) )
它显示:错误1146 (42S02):表'test.Rel‘不存在
发布于 2014-11-08 00:26:21
最后的subselect似乎不能引用FROM子句中定义的嵌套查询。
在这种情况下,您有多个解决方案:
WITH语句<代码>H210<代码>F211复制可以在任何情况下工作:
SELECT Rel.total
FROM (
SELECT H.number, H.teamname, SUM(H.numberofgoals) AS total
FROM HaveGoal H
GROUP BY H.number,H.teamname
) AS Rel
WHERE Rel.total = (
SELECT MAX(Rel2.total)
FROM (
SELECT H.number, H.teamname, SUM(H.numberofgoals) AS total
FROM HaveGoal H
GROUP BY H.number,H.teamname
) AS Rel2
)排序后的第一行要短得多,但MAX是隐含的:
SELECT Rel.total
FROM (
SELECT H.number, H.teamname, SUM(H.numberofgoals) AS total
FROM HaveGoalTest H
GROUP BY H.number,H.teamname
) AS Rel
ORDER BY total DESC
LIMIT 1https://stackoverflow.com/questions/26804111
复制相似问题