I want to list fetched vertex by label.
How can I find all labels and counts of fetched vertex?
Use LABLE function with distinct keyword.
agens=# match (f)-[:mgr]->(t) return distinct label(f), label(t); label | label -------------+------------ "analyst" | "clerk" "manager" | "analyst" "manager" | "clerk" "manager" | "salesman" "president" | "manager" (5 rows) agens=# match (f)-[:mgr]->(t) return label(f) , label(t), count(*); label | label | count -------------+------------+------- "analyst" | "clerk" | 2 "manager" | "analyst" | 2 "manager" | "clerk" | 2 "manager" | "salesman" | 4 "president" | "manager" | 3 (5 rows)
Copyright © 2021 Jogjafile Inc.
Use LABLE function with distinct keyword.