diff options
| author | Zolnai Tamás <root@linux-dre0.site> | 2013-03-03 00:47:05 +0100 |
|---|---|---|
| committer | Zolnai Tamás <zolnaitamas2000@gmail.com> | 2013-03-04 17:12:40 +0100 |
| commit | 80057f99f605bb833eaa93a6cfc21b593a302783 (patch) | |
| tree | 193b9c1859fcdde5b3a2165cf150d2d26338e1e1 /source/text/shared/explorer | |
| parent | 8274992b1f66d9fb5766afd9fc427038f64de5e0 (diff) | |
Add help for Limit
Change-Id: I15ae938b8e07298191246231b00efae0c1315a74
Diffstat (limited to 'source/text/shared/explorer')
| -rw-r--r-- | source/text/shared/explorer/database/02010100.xhp | 3 |
1 files changed, 3 insertions, 0 deletions
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 @@ <paragraph role="paragraph" id="par_id3150436" xml-lang="en-US" l10n="U" oldref="159">For example, if the name "Smith" occurs several times in your address database, you can choose the<emph> Distinct Values</emph> command to specify in the query that the name "Smith" will occur only once.</paragraph> <paragraph role="paragraph" id="par_id3152352" xml-lang="en-US" l10n="U" oldref="160">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<emph> Distinct Values</emph> 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.</paragraph> <paragraph role="paragraph" id="par_id3149825" xml-lang="en-US" l10n="U" oldref="161">In SQL, this command corresponds to the DISTINCT predicate.</paragraph> +<paragraph role="heading" id="hd_id3153290" xml-lang="en-US" level="3">Limit</paragraph> +<paragraph role="paragraph" id="par_id3147501" xml-lang="en-US"><ahelp hid="HID_QRYDGN_ROW_FUNCTION">Allows you to maximize the number of records with which query returns.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3152350" xml-lang="en-US">If there is added a <emph>Limit</emph>, you will get at most as many rows as the number you specify. Otherwise, you will see all records corresponding to the query criteria.</paragraph> <paragraph role="heading" id="hd_id3148926" xml-lang="en-US" level="3" l10n="U" oldref="37">Formulating filter conditions</paragraph> <section id="abfragekriterien"> <paragraph role="paragraph" id="par_id3153162" xml-lang="en-US" l10n="U" oldref="38">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:</paragraph> |