Below statement get nodes and their relationships
MATCH (n1)-[rel]-(n2) RETURN n1, rel, n2
Let’s see it with an example.
Step 1: Open neo4j browser by hitting following url in browser.
http://localhost:7474/browser/
Step 2: Insert data by executing below query.
CREATE (p1:Person{name: "Rama Krishna", age: 32, city: "Bangalore", male: true, designation: "CEO"}), (p2:Person{name: "Murali", age: 32, city: "Hyderabad", male: true, designation: "Vice President"}), (p3:Person{name: "Gopi", age: 34, city: "Chennai", male: true, designation: "Vice President"}), (p4:Person{name: "Kiran", age: 28, city: "Bangalore", male: true, designation: "Director"}), (p5:Person{name: "Siva", age: 45, city: "Hyderabad", male: true, designation: "Director"}), (p6:Person{name: "Kiran", age: 36, city: "Hyderabad", male: true, designation: "Manager"}), (p7:Person{name: "Ritweek", age: 23, city: "Bangalore", male: true, designation: "Manager"}), (p8:Person{name: "Sudheer", age: 24, city: "Chennai", male: true, designation: "Manager"}), (p9:Person{name: "Naveen", age: 37, city: "Bangalore", male: true, designation: "Employee"}), (p10:Person{name: "Sailaja", age: 31, city: "Hyderabad", female: true, designation: "Employee"}), (p11:Person{name: "Harika", age: 36, city: "Bangalore", female: true, designation: "Employee"}), (p12:Person{name: "Brahmam", age: 41, city: "Bangalore", male: true, designation: "Employee"}), (office1:Location{name: "Pluto", city: "Bangalore"}), (office2:Location{name: "Mars", city: "Chennai"}) MERGE (p2)-[:REPORT_TO{from: "2014"}]->(p1) MERGE (p3)-[:REPORT_TO{from: "2016"}]->(p1) MERGE (p4)-[:REPORT_TO{from: "1997"}]->(p2) MERGE (p5)-[:REPORT_TO{from: "1987"}]->(p3) MERGE (p6)-[:REPORT_TO{from: "2001"}]->(p4) MERGE (p7)-[:REPORT_TO{from: "2009"}]->(p4) MERGE (p8)-[:REPORT_TO{from: "1998"}]->(p5) MERGE (p9)-[:REPORT_TO{from: "2003"}]->(p6) MERGE (p10)-[:REPORT_TO{from: "2004"}]->(p6) MERGE (p11)-[:REPORT_TO{from: "2008"}]->(p7) MERGE (p12)-[:REPORT_TO{from: "2019"}]->(p8) RETURN p1, p2, p3, p4, p5, p6, p7, p8, p9, p10, p11, p12, office1, office2
Step 3: Execute below query to get nodes and their relationship.
MATCH (n1)-[rel]-(n2) RETURN n1, rel, n2
Click on ‘Table’ icon available at left side of the page.
As you see above image, you can see nodes and the relationships information in table format.
Previous Next Home
No comments:
Post a Comment