SQL++ - Quick review

Before we continue exploring N1QL further, let us take a look at a query that summarizes what we've learned so far.

Here we match people having a yahoo email address or having some of their children over the age of 10. For each person satisfying these requirements, we display their full name, email address, and the full list of children.

Try appending the expression USE KEYS ['dave', 'ian'] after the FROM expression to restrict the scope of the query to primary keys "dave" and "ian".

To run this example, click the button in the top right corner of the code editor.

Code Editor

Output