How do I display the nodes with the most properties
To display the nodes with the most properties defined, run the following Cypher:
MATCH (n)
RETURN labels(n), keys(n), size(keys(n)), count(*)
ORDER BY size(keys(n)) DESCRepresentative output is similar to:
| labels(n) | keys(n) | size(keys(n)) | count(*) |
|---|---|---|---|
[Movie] |
[TotalRevenue, year_of_release, name, id] |
4 |
1 |
[Movie] |
[TotalRevenue, name, id] |
3 |
2 |
[Artist] |
[name, year] |
2 |
4 |
The first row of output indicates that there is a Label named Movie, which has 4 properties (TotalRevenue, year_of_release, name, id) and there is 1 node defined with that Label and those properties.
The second row of output indicates that there is a Label named Movie which has 3 properties (TotalRevenue, name, id) and there are 2 nodes defined as such.
The third row of output indicates that there is a Label named Artists which has 2 properties (name, year) and there are 4 nodes defined as such.
Is this page helpful?