LibreOffice Help – 7.6/text/sdatabase — Chinese (Simplified) @ TDF Weblate - LibreOffice: SELECT FUNCTION(column) FROM table.

Translation

Context 02010100.xhp par_id3156340 help.text

English

Qg6Ue

Chinese (Simplified)

Needs editing

Skip

Context	English	Chinese (Simplified)
02010100.xhp par_id3166420 help.text	Average	平均值
02010100.xhp par_id3154486 help.text	Calculates the arithmetic mean of a field.	计算字段的算术平均值。
02010100.xhp par_id3149979 help.text	Count	计数
02010100.xhp par_id3155810 help.text	Determines the number of records in the table. Empty fields can either be counted (a) or excluded (b).	确定表中的记录数。空字段可以参与计数（a）或被排除（b）。
02010100.xhp par_id3151333 help.text	a) COUNT(*): Passing an asterisk as the argument counts all records in the table.	a) COUNT(*): 传递星号作为参数对表中的所有记录进行计数。
02010100.xhp par_id3152889 help.text	b) COUNT(column): Passing a field name as an argument counts only the records in which the specified field contains a value. Records in which the field has a Null value (i.e. contains no textual or numeric value) will not be counted.	b) COUNT (column)：将字段名作为参数传递仅统计指定字段中包含值的记录。字段值为空（即不包含文本或数字值）的记录将不被统计。
02010100.xhp par_id3153067 help.text	Maximum	最大值
02010100.xhp par_id3159221 help.text	Determines the highest value of a record for that field.	确定该字段记录的最大值。
02010100.xhp par_id3146866 help.text	Minimum	最小值
02010100.xhp par_id3157982 help.text	Determines the lowest value of a record for that field.	确定该字段记录的最小值。
02010100.xhp par_id3154828 help.text	Sum	求和
02010100.xhp par_id3154536 help.text	Calculates the sum of the values of records for the associated fields.	计算关联字段的记录值之和。
02010100.xhp par_id3148820 help.text	Group	分组
02010100.xhp par_id3149438 help.text	Groups query data according to the selected field name. Functions are executed according to the specified groups. In SQL, this option corresponds to the GROUP BY clause. If a criterion is added, this entry appears in the SQL HAVING sub-clause.	根据所选字段名称对查询数据分组。根据指定的组执行函数。在SQL中，此选项对应于GROUP BY子句。如果添加了条件，则此条目将出现在SQL HAVING子子句中。
02010100.xhp par_id3156038 help.text	You can also enter function calls directly into the SQL statement. The syntax is:	您还可以直接在SQL语句中输入函数调用。语法为：
02010100.xhp par_id3156340 help.text	SELECT FUNCTION(column) FROM table.	SELECT FUNCTION(column) FROM table.
02010100.xhp par_id3155075 help.text	For example, the function call in SQL for calculating a sum is:	例如，SQL中用于求和的函数调用为：
02010100.xhp par_id3154591 help.text	SELECT SUM("Price") FROM "Article".	SELECT SUM("Price") FROM "Article".
02010100.xhp par_id3159205 help.text	Except for the <emph>Group</emph> function, the above functions are called Aggregate functions. These are functions that calculate data to create summaries from the results. Additional functions that are not listed in the list box might be also possible. These depend on the specific database engine in use and on the current functionality provided by the Base driver used to connect to that database engine.	除了<emph>组合</emph>函数外，上述函数称为聚合函数。这些函数用于计算数据以根据结果创建汇总数。也可以使用列表框中未列出的其他函数。这取决于使用中的特定数据库引擎以及用于连接到该数据库引擎的基本驱动程序提供的当前功能。
02010100.xhp par_id3148651 help.text	To use other functions not listed in the list box, you must enter them manually under <emph>Field</emph>.	要使用列表框中未列出的其他功能，必须在<emph>字段</emph>下手动输入。
02010100.xhp par_id3155098 help.text	You can also assign aliases to function calls. If you do not want to display the query string in the column header, enter a desired substitute name under <emph>Alias</emph>.	还可以为函数调用指定别名。如果不想在列标题中显示查询字符串，请在<emph>别名</emph>下输入所需的替换名称。
02010100.xhp par_id3155539 help.text	The corresponding function in an SQL statement is:	SQL语句中对应的函数是：
02010100.xhp par_id3149425 help.text	SELECT FUNCTION() AS alias FROM table	SELECT FUNCTION() AS alias FROM table
02010100.xhp par_id3144431 help.text	Example:	示例：
02010100.xhp par_id3154614 help.text	SELECT COUNT(*) AS count FROM "Item"	SELECT COUNT(*) AS count FROM "Item"
02010100.xhp par_id3154610 help.text	If you run such a function, you cannot insert any additional columns for the query other than as an argument in a "Group" function.	如果运行这样的函数，则除了作为“Group”函数中的参数外，不能为查询插入任何其他列。
02010100.xhp par_id3154644 help.text	<emph>Examples</emph>	<emph>示例</emph>
02010100.xhp par_id3151120 help.text	In the following example, a query is run through two tables: an "Item" table with the "Item_No" field and a "Suppliers" table with the "Supplier_Name" field. In addition, both tables have a common field name "Supplier_No."	在下列示例中，在两个表之间执行了一个查询：表 "Item" 及其 "Item_No" 字段，以及表 "Suppliers" 及其 "Supplier_Name" 字段。另外，两个表中都存在一个共同的字段名："Supplier_No"。
02010100.xhp par_id3155144 help.text	The following steps are required to create a query containing all suppliers who deliver more than three items.	要创建包含交付三个以上项目的所有供应商的查询，需要执行以下步骤。
02010100.xhp par_id3153240 help.text	Insert the "Item" and "Suppliers" tables into the query design.	在查询设计中插入“Item”和“Suppliers”表。
02010100.xhp par_id3148807 help.text	Link the "Supplier_No" fields of the two tables if there is not already a relation of this type.	如果还没有此类关系，请链接两个表的“Supplier_No”字段。

Loading…

suokunlong

Translation added

English

Chinese (Simplified) 35 characters edited Current translation Translated

12 months ago

None

String updated in the repository

English

Chinese (Simplified) 0 characters edited Empty

a year ago

Browse all string changes

Things to check

Unchanged translation

Source and translation are identical

Reset

Glossary

English	Chinese (Simplified)
No related strings found in the glossary.

String information

Context

02010100.xhp
par_id3156340
help.text

Source string description

Qg6Ue

Source string location

02010100.xhp

String age

a year ago

Last updated

a year ago

Source string age

a year ago

Translation file

zh-CN/helpcontent2/source/text/sdatabase.po, string 135