Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Queries built in the NoSQL query language are constructed of various supported clauses that are built in to the query language.
Clauses
Here's a list of clauses that the NoSQL query language currently supports:
| Description | |
|---|---|
FROM |
The FROM clause identifies the source of data for a query. |
GROUP BY |
The GROUP BY clause collects rows that have the same values into summary rows. |
OFFSET LIMIT |
The OFFSET LIMIT clause returns a subset of the result set by skipping a specified number of results and then taking a specified number of results. |
ORDER BY RANK |
The ORDER BY RANK clause returns the sorted result set of a query based on the rank of scoring functions. |
ORDER BY |
The ORDER BY clause returns the sorted result set of a query based on one or more expressions. |
SELECT |
The SELECT clause identifies fields to return in query results. The clause then projects those fields into the JSON result set. |
WHERE |
The WHERE clause returns a subset of items that satisfy the specified filter condition. |
| Description | |
|---|---|
| Subquery | A subquery clause identifies a query nested within another query. |