Learning Couchbase

Operation types

With the release of DP4, N1QL is a full-fledged SQL-like language meant to fetch and perform various operations on a JSON based document stored in the bucket. Since we are working on N1QL DP3, we will only discuss the features provided by it, as follows:

Category	Description
Select	This provides features to extract the desired attributes from documents present in the bucket
Filter	You can filter documents according to the conditions of your application logic
Aggregate	You can perform aggregation by grouping attributes specified in the aggregate clause
Having	You can filter documents on the aggregate value after applying aggregation functions
Order	You can order resultset documents
Skip	You can perform skipping ...