Questions Linux Laravel Mysql Ubuntu Git Menu

HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin

How to get different labels and their count in neo4j by cypher query?

Tags:

count

neo4j

cypher

I was needing to check what different labels present in graph database neo4j.

How to get different labels and their count in neo4j by cypher query?

like image

630

asked Apr 28 '14 07:04

Somnath Muluk

1 Answers

I finally found a solution to the multiple label problem that is less complicated:

MATCH (a) WITH DISTINCT LABELS(a) AS temp, COUNT(a) AS tempCnt
UNWIND temp AS label
RETURN label, SUM(tempCnt) AS cnt

like image

113

answered Oct 18 '22 19:10

accidental_PhD

Sign in to Comment

Related questions
                            
                                How do I implement SQL_CALC_FOUND_ROWS on a query with UNION?
                            
                                PHP - count li elements inside ul
                            
                                SQL: Count distinct values from one column based on multiple criteria in other columns
                            
                                Efficient Way to Incrementally Count Unique Data Points in Data Frame
                            
                                Counting number of same values in map
                            
                                Counting distinct items within a category on SQL
                            
                                SQL Count multiple columns
                            
                                Python: Counting occurrences of List element within List
                            
                                How to get the number of rows in a table in a Datastore?
                            
                                Filtered count and total count without subquery
                            
                                SQL query - multiple COUNT on same column with different values from nested SELECT query
                            
                                Generic List, items counting with conditional-statement
                            
                                Get number of rows in Laravel's Eloquent before using "take" and "skip"
                            
                                cakePHP - how do i get the items count for a related model?
                            
                                How to count the number of two observations binary combinations?
                            
                                counting number of empty inputs with a certain class
                            
                                counting occurrence of particular letter in vector of words in r
                            
                                SQL select & group by a period of time (timestamp)
                            
                                Is there anyway to count how many keys an array has in Php?
                            
                                How can I count overlapping substrings in Perl?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With