If you have experience with SQL, then sorting with Cypher is exactly the same as sorting with SQL. We can use the ORDER BY
clause to specify the columns to be used for sorting, as shown in the following query:
MATCH (b:Book)
WHERE ANY ( tag IN b.tags WHERE tag IN ['drama'] )
RETURN b.title
ORDER BY b.title
LIMIT 5
The preceding query looks for books tagged drama
in the database, then sorts them by title, and returns the first five book entries found. We can note the following:
The
ORDER BY
clause follows theRETURN
clauseThis clause is above the
LIMIT
orSKIP
clause so that we can sort the data before limiting our page
+-----------------------------+ | b.title | +-----------------------------+ | "A Lover's Complaint" | | "A Midsummer Night's Dream" | | "All's Well That Ends Well" | | "Anthony and Cleopatra" | | "As You Like It" | +-----------------------------+