错误(ORA-00923:在预期位置找不到FROM关键字) [英] Error (ORA-00923: FROM keyword not found where expected)

问题描述

    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关键字未在预期位置找到，并且不知道为什么，请帮助

I have been getting the error ORA-00923: FROM keyword not found where expected and do not know why, please help

推荐答案

标识符必须用双引号(")引起来.单引号(')表示字符 value (不是名称").

Identifiers need to be quoted with double quotes ("). Single quotes (') denote a character value (not a "name").

因此，您需要使用:

SUM(part_gold) as "Number of Gold Medals"

手册中的更多详细信息:

More details in the manual:

• 数据库对象名称和限定符
• 文本文字

• Database Object Names and Qualifiers
• Text literals

这篇关于错误(ORA-00923:在预期位置找不到FROM关键字)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！