请问一下，正常query的时候报错：Function and is not a unary operator

做正常query的时候报错：Function and is not a unary operator

select  
  a as code
from    data 
where   instrumentkind != 'Future'
  and instrumentkind != 'Combo' 
  and instrumentkind != 'VolatilityTrade'
context by instrument_code csort time limit 1

0 条评论
分类：技术问答

默认排序时间排序

1 个回答

Shena Mao 2021-08-27 17:31

这个是换行导致的问题，改成以下就可以：

select a as code
from    data 
where   instrumentkind != 'Future' and instrumentkind != 'Combo' and instrumentkind != 'VolatilityTrade'
context by instrument_code csort time limit 1

请问一下，正常query的时候报错：Function and is not a unary operator

1 个回答

相似问题