06.5.1.Functions - Aggregations
COUNT()
返回非空值的数量
语法
xxxxxxxxxx
1
1
SELECT COUNT( [ * | <field_key> | /<regular_expression>/ ] ) [INTO_clause] FROM_clause [WHERE_clause] [GROUP_BY_clause] [ORDER_BY_clause] [LIMIT_clause] [OFFSET_clause] [SLIMIT_clause] [SOFFSET_clause]
嵌套语法
xxxxxxxxxx
1
1
SELECT COUNT(DISTINCT( [ * | <field_key> | /<regular_expression>/ ] )) […]
COUNT(field_key)语法描述
1
COUNT(field_key) # 返回field_key字段的数目
更多信息见:https://docs.influxdata.com/influxdb/v1.2/query_language/functions/#count