APIJSON icon indicating copy to clipboard operation
APIJSON copied to clipboard
verified publisher icon Tencent

[使用问题]按年聚合筛选条件怎么写法

Open jwcjf opened this issue 2 years ago • 1 comments

Description

image

jwcjf avatar May 23 '23 09:05 jwcjf

SQL 中用 HAVING，对应 APIJSON 就是 "@having": "year(ftime)=2022"

如果不是聚合函数，则可以用 WHERE： "ftime{}": "year(ftime)=2022"

具体见通用文档 https://github.com/Tencent/APIJSON/blob/master/Document.md#3.2

TommyLemon avatar May 23 '23 14:05 TommyLemon