Top

Table of Contents



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

Notes on ordering

  • 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.


round-pushpin Returns the first 10 documents that are gathered by the query.
SELECT TOP 10 * FROM WordList:Word


round-pushpin Orders the Word by text and then returns the first 10 documents.
SELECT TOP 10 * FROM WordList:Word ORDER BY Text



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