Top

Table of Contents

Overview
The top keywork limits the number of results that are returned by a query.

Due to threading, the TOP limiter will not necessarily return the first documents in a namespace.
When using the TOP limiter with ORDER BY, the full result set will be ordered before the limiter is applied.

Returns the first 10 documents that are gathered by the query.

SELECT TOP 10 * FROM WordList:Word

Orders the Word by text and then returns the first 10 documents.

SELECT TOP 10 * FROM WordList:Word ORDER BY Text

Order By - Order by allows you to sort a result-set by a given set of fields.
Keywords - A breakdown of all high-level statements available via the query handler.