Tag: analytical functions

Deep Dive: Window functions in Couchbase Analytics
Couchbase Analytics
Deep Dive: Window functions in Couchbase Analytics

Couchbase Server 6.5 brings a host of new features [1] to the leading NoSQL database. One of the key additions to the N1QL query language is support for window functions. These functions were originally introduced in the SQL:2003 standard and provide...

Dmitry Lychagin, Principal Engineer, Couchbase
September 20, 2019 | 6 MIN READ
6.5 / analytical functions / reporting
Get a Bigger Picture with N1QL Window Functions and CTE
SQL++ / N1QL Query
Get a Bigger Picture with N1QL Window Functions and CTE

This article focuses on a couple of examples of how you can leverage N1QL Window functions and CTE to address two very common business questions.

Binh Le
March 12, 2019 | 5 MIN READ
6.5 / analytical functions
On Par with Window Functions.
SQL++ / N1QL Query
On Par with Window Functions.

This post focuses on Window Functions and it's purpose. How to write a query without using windows functions and with Window functions in Mad-Hatter.

Keshav Murthy
November 22, 2018 | 4 MIN READ
6.5 / analytical functions / JSON / NoSQL Database / reporting