sql - 错误(ORA-00923 : FROM keyword not found where expected)

Question

    select 
      country_olympic_name, 
      SUM(part_gold) as 'Number of Gold Medals'
    From
      games.country,
      games.participation
   where
      participation.country_isocode = country.country_isocode
   group by
      country_olympic_name;

我收到错误 ORA-00923: FROM 关键字未在预期位置找到，并且不知道原因，请帮助

Answer 1

标识符需要用双引号 (") 括起来。单引号 (') 表示字符值(而不是“名称” ”)。

因此您需要使用:

SUM(part_gold) as "Number of Gold Medals"

手册中的更多详细信息:

• Database Object Names and Qualifiers
• Text literals