This repository has been archived by the owner on Dec 1, 2022. It is now read-only.

count, avg, sum support condition filter #1320

Closed

blacklovebear opened this issue Aug 17, 2021 · 1 comment

blacklovebear commented Aug 17, 2021 •

edited

current problem
count (age>30) no effect. The result just same with count(*)
want result
age, sex
10, M
20, F
30, F
40, M

count(age>20) return 2, count(sex == 'M') return 2

Contributor

czpmango commented Aug 19, 2021

RETURN count(case when age>20 then true end)

czpmango closed this as completed

jamieliu1023 mentioned this issue

Weekly Report 2021-08-21 vesoft-inc/nebula-community#22

Closed

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.