| const e=JSON.parse('{"key":"v-25f2e384","path":"/zh/UserGuide/Master/stage/Query-Data/Having-Condition.html","title":"聚合结果过滤","lang":"zh-CN","frontmatter":{"description":"如果想对聚合查询的结果进行过滤，可以在 GROUP BY 子句之后使用 HAVING 子句。 注意： 1. HAVING子句中的过滤条件必须由聚合值构成，原始序列不能单独出现。 下列使用方式是不正确的： 2. 对GROUP BY LEVEL结果进行过滤时，SELECT和`HAVING`中出现的PATH只能有一级。 下列使用方式是不正确的： SQL 示例...","head":[["link",{"rel":"alternate","hreflang":"en-us","href":"https://iotdb.apache.org/UserGuide/Master/stage/Query-Data/Having-Condition.html"}],["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/Master/stage/Query-Data/Having-Condition.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"聚合结果过滤"}],["meta",{"property":"og:description","content":"如果想对聚合查询的结果进行过滤，可以在 GROUP BY 子句之后使用 HAVING 子句。 注意： 1. HAVING子句中的过滤条件必须由聚合值构成，原始序列不能单独出现。 下列使用方式是不正确的： 2. 对GROUP BY LEVEL结果进行过滤时，SELECT和`HAVING`中出现的PATH只能有一级。 下列使用方式是不正确的： SQL 示例..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"zh-CN"}],["meta",{"property":"og:locale:alternate","content":"en-US"}],["meta",{"property":"og:updated_time","content":"2023-10-25T07:33:02.000Z"}],["meta",{"property":"article:modified_time","content":"2023-10-25T07:33:02.000Z"}],["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"聚合结果过滤\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2023-10-25T07:33:02.000Z\\",\\"author\\":[]}"]]},"headers":[],"git":{"createdTime":1698219182000,"updatedTime":1698219182000,"contributors":[{"name":"dependabot[bot]","email":"49699333+dependabot[bot]@users.noreply.github.com","commits":1}]},"readingTime":{"minutes":2.07,"words":621},"filePathRelative":"zh/UserGuide/Master/stage/Query-Data/Having-Condition.md","localizedDate":"2023年10月25日","autoDesc":true}');export{e as data}; |