In a drug database, some of the drugs have multiple ids. I want to select all drugs with more than 1 ids. Basically, I am trying to implement the GROUP BY and HAVING clause of SQL in Cypher. What is the equivalent for it?
My SQL query looks like this:
select name, count(id) as idcount
group by name