how to use subquery

[Anwenya]

is any way count with distinct in subquery？

MATCH (a:Account)-[cw:ContactWith]-()                                                                 
WITH a,  { MATCH (a)-[:ContactWith]-(f:Account) RETURN COUNT(DISTINCT f) } AS f_count, { MATCH (a)-[:ContactWith]-(g:`Group`) RETURN COUNT(DISTINCT g) } AS g_count
RETURN a, f_count, g_count

[andyfengHKU]

Hi @Anwenya,

We don't yet support distinct aggregate within subquery. Regarding the semantic of

WITH a,  { MATCH (a)-[:ContactWith]-(f:Account) RETURN COUNT(DISTINCT f) } AS f_count

Are you trying to count the distinct account for each a? If so, I wonder if the following will work

MATCH (a:Account)-[cw:ContactWith]-()                                                                 
WITH a
MATCH (a)-[:ContactWith]-(f:Account) 
RETURN a, COUNT(DISTINCT f) AS f_count

[Anwenya]

ok,thanks