From 80057f99f605bb833eaa93a6cfc21b593a302783 Mon Sep 17 00:00:00 2001 From: Zolnai Tamás Date: Sun, 3 Mar 2013 00:47:05 +0100 Subject: Add help for Limit Change-Id: I15ae938b8e07298191246231b00efae0c1315a74 --- AllLangHelp_shared.mk | 1 + source/text/shared/02/limit.xhp | 26 +++++++++++++++++++++++ source/text/shared/explorer/database/02010100.xhp | 3 +++ 3 files changed, 30 insertions(+) create mode 100644 source/text/shared/02/limit.xhp diff --git a/AllLangHelp_shared.mk b/AllLangHelp_shared.mk index 86043e5ee5..d30624b900 100644 --- a/AllLangHelp_shared.mk +++ b/AllLangHelp_shared.mk @@ -493,6 +493,7 @@ $(eval $(call gb_AllLangHelp_add_helpfiles,shared,\ helpcontent2/source/text/shared/02/colortoolbar \ helpcontent2/source/text/shared/02/flowcharts \ helpcontent2/source/text/shared/02/fontwork \ + helpcontent2/source/text/shared/02/limit \ helpcontent2/source/text/shared/02/more_controls \ helpcontent2/source/text/shared/02/paintbrush \ helpcontent2/source/text/shared/02/querypropdlg \ diff --git a/source/text/shared/02/limit.xhp b/source/text/shared/02/limit.xhp new file mode 100644 index 0000000000..297c0ebc0f --- /dev/null +++ b/source/text/shared/02/limit.xhp @@ -0,0 +1,26 @@ + + + + + + + + Limit + /text/shared/02/limit.xhp + + + +SQL; LIMIT clause + +Limit + +Expands the created select statement of the SQL Query by the LIMIT X clause. This can be used to limit your SQL Query results to those that fall within the the first X number of it. + + diff --git a/source/text/shared/explorer/database/02010100.xhp b/source/text/shared/explorer/database/02010100.xhp index fb3990f639..2a832d17ae 100644 --- a/source/text/shared/explorer/database/02010100.xhp +++ b/source/text/shared/explorer/database/02010100.xhp @@ -313,6 +313,9 @@ For example, if the name "Smith" occurs several times in your address database, you can choose the Distinct Values command to specify in the query that the name "Smith" will occur only once. For a query involving several fields, the combination of values from all fields must be unique so that the result can be formed from a specific record. For example, you have "Smith in Chicago" once in your address book and "Smith in London" twice. With the Distinct Values command, the query will use the two fields "last name" and "city" and return the query result "Smith in Chicago" once and "Smith in London" once. In SQL, this command corresponds to the DISTINCT predicate. +Limit +Allows you to maximize the number of records with which query returns. +If there is added a Limit, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria. Formulating filter conditions
When formulating filter conditions, various operators and commands are available to you. Apart from the relational operators, there are SQL-specific commands that query the content of database fields. If you use these commands in the $[officename] syntax, $[officename] automatically converts these into the corresponding SQL syntax. You can also enter the SQL command directly. The following tables give an overview of the operators and commands: -- cgit