This is an automated email from the ASF dual-hosted git repository.
zykkk pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 004d3264a6c [typo](docs) add 'order by' when use 'limit m,n' (#24236)
004d3264a6c is described below
commit 004d3264a6cc03ee3863967e03e7ae4bf105ec1d
Author: lsy3993 <[email protected]>
AuthorDate: Wed Oct 11 16:15:33 2023 +0800
[typo](docs) add 'order by' when use 'limit m,n' (#24236)
---
.../sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md | 2 +-
.../sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
index 67b80fc91db..f3d5df71842 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
@@ -77,7 +77,7 @@ SELECT
If you need to return the top N sorted results, you need to use the
LIMIT clause; in order to limit memory usage, if the user does not specify the
LIMIT clause, the first 65535 sorted results are returned by default.
- 9. `Limit n`: limit the number of lines in the output result, `limit m,n`
means output n records starting from the mth line.
+ 9. `Limit n`: limit the number of lines in the output result, `limit m,n`
means output n records starting from the mth line.You should use `order by`
before you use `limit m,n`, otherwise the data may be inconsistent each time it
is executed.
10. The `Having` clause does not filter the row data in the table, but
filters the results produced by the aggregate function.
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
index 262a1dd9222..7c11caf93b7 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/SELECT.md
@@ -77,7 +77,7 @@ SELECT
如果需要返回前 N 个排序结果，需要使用 LIMIT 从句；为了限制内存的使用，如果用户没有指定 LIMIT 从句，则默认返回前 65535
个排序结果。
-9. `Limit n`: 限制输出结果中的行数，`limit m,n` 表示从第m行开始输出n条记录。
+9. `Limit n`: 限制输出结果中的行数，`limit m,n` 表示从第m行开始输出n条记录，**使用limit m,n的时候要加上order
by才有意义，否则每次执行的数据可能会不一致**
10. `Having` 从句不是过滤表中的行数据，而是过滤聚合函数产出的结果。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
