srowen commented on a change in pull request #27290: [SPARK-30583][DOC] Document LIMIT Clause of SELECT statement in SQL Reference URL: https://github.com/apache/spark/pull/27290#discussion_r368608284
########## File path: docs/sql-ref-syntax-qry-select-limit.md ########## @@ -18,5 +18,71 @@ license: | See the License for the specific language governing permissions and limitations under the License. --- +The <code>LIMIT</code> clause is used to constrain the number of rows returned by the <code>SELECT</code> statement. +In general, this clause is used in conjuction with <code>ORDER BY</code> to ensure that the results are deterministic. -**This page is under construction** +### Syntax +{% highlight sql %} +LIMIT { ALL | integer_expression } +{% endhighlight %} + +### Parameters +<dl> + <dt><code><em>ALL</em></code></dt> + <dd> + If specified, the query returns all the rows. In otherwords, no limit is applied if this Review comment: other words ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org