运行此SQL语句:
select TimeInterval,
((((Timer*60)/1.0)*100)/((10.0*60)/60.0)) as 'Throughput-run_1_8_11'
from StatExternalData, StatisticDefinition
where StatisticDefinition.ID=StatExternalData.StatDefId
and StatisticName='PSI_CompTran_Successful_Cnt'
order by TimeInterval asc
我遇到了这个错误:
"select TimeInterval, ((((Timer*60)/1.0)*100)/((10.0*60)/60.0)) as 'Throughput-run_1_8_11'[*] from StatExternalData, StatisticDefinition where StatisticDefinition.ID=StatExternalData.StatDefId and StatisticName='PSI_CompTran_Successful_Cnt' order by TimeInterval asc";
expected "identifier"; [42001-185]
我已经弄清楚[*]表示哪部分陈述是不正确的,而H2错误代码42001表示SQL语句无效,但我已经努力了几周,仍然想不出问题出在哪里。有没有人有什么想法?
" "
而不是单引号 (' '
) 将列别名括起来吗? - BarrankaThroughput_run_1_8_11
**代替Throughput-run_1_8_11
。 - Barranka