处理所有
选择MAX( inflation_rate )作为max_inf,(选择名称、大陆、来自内部经济体的inflation_rate,使用(代码)其中年份=2015年)作为子查询组,由max_inf作为子查询组,这是不正确的代码
选择MAX(subquery.economies.inflation_rate)作为max_inf FROM (从各国内部选择countries.name、countries.continent、economies.inflation_rate作为countries.code = economies.code的子查询组,其中economies.year = 2015)为子查询组
为什么第二张不允许?
发布于 2019-10-07 12:49:42
SELECT
MAX(subquery.economies.inflation_rate) AS max_inf -- 3
FROM (
SELECT
countries.name, -- 1
countries.continent,
economies.inflation_rate
FROM ...) AS subquery -- 2
GROUP BY
subquery.countries.continent; -- 3您正在使用子查询(2)。该子查询返回三列:name、continent、inflation_rate (1)。在子查询之外只知道这些名称,但没有其他名称。因此,上级查询不知道列名来自何处。表或表架构与此无关。
因此,对于高级查询,唯一相关的信息是:子查询的名称和列名(3):
SELECT
MAX(subquery.inflation_rate) AS max_inf -- change
FROM (
SELECT
countries.name,
countries.continent,
economies.inflation_rate
FROM ...) AS subquery
GROUP BY
subquery.continent; -- change发布于 2019-10-07 12:42:55
您不需要编写subquery.countries.continent,因为您有一个子查询并重新命名了它--所以subquery.continent就足够了
SELECT MAX(subquery.inflation_rate) AS max_inf FROM
(SELECT countries.name, countries.continent, economies.inflation_rate
FROM countries INNER JOIN economies
ON countries.code = economies.code
WHERE economies.year = 2015) AS subquery
GROUP BY subquery.continent发布于 2019-10-07 12:48:34
因为我假设这是postgresql,所以可以简化它并去掉子查询。
SELECT continent
, max(inflation_rate) as max_inf
FROM countries
INNER JOIN economies USING (code)
WHERE year = 2015
group by continenthttps://stackoverflow.com/questions/58269748
复制相似问题