You are looking at documentation for an older release. Not what you want? See the current release documentation.
Query: Select all documents in default order (by document name).
Initial data:
document1: Title - Apollo 7
document2: Title - Apollo 8
document3: Title - Apollo 13
document4: Title - Apollo 17
SELECT cmis:lastModifiedBy, cmis:objectId, cmis:lastModificationDate FROM cmis:document
Query result:
document3, document4, document1, document2.