หมายเหตุ
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลอง ลงชื่อเข้าใช้หรือเปลี่ยนไดเรกทอรีได้
การเข้าถึงหน้านี้ต้องได้รับการอนุญาต คุณสามารถลองเปลี่ยนไดเรกทอรีได้
Queries built in the 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 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. |