Select Subdocumnet with N1QL

Yes Checkout https://developer.couchbase.com/documentation/server/5.0/n1ql/n1ql-language-reference/select-syntax.html

Examples at https://developer.couchbase.com/documentation/server/5.0/n1ql/n1ql-language-reference/selectintro.html

If you need to sort the array or limit array elements use subquery expression you can find documentation . Also checkout Multiple join from different bucket