Translation of "sql aggregate function" in Japanese
We couldn’t find this entry. Showing approximate results. Check your spelling or suggest adding this term to the dictionary.
SQL 集計関数
An SQL aggregate function that operates on the selected data.
選択したデータを集計する SQL 集計関数。
You can use the string expression argument in an SQL aggregate function to perform a calculation on values in a field.
SQL 集計関数では、文字列式の引数を指定してフィールドの値に関する計算を実行できます。
You can use the string expression argument in an SQL aggregate function to perform a calculation on values in a field. For example, you could calculate a percentage (such as a surcharge or sales tax) by multiplying a field value by a fraction.
An expression that identifies the field containing the numeric data you want to average. It can be a string expression identifying a field in a table or query, or it can be an expression that performs a calculation on data in expr, you can include the name of a field in a table, a control on a form, a constant, or a function. If expr includes a function, it can be either built-in or user-defined, but not another domain aggregate or SQL aggregate function.
Summary values are omitted if there is no SQL aggregate function in the SELECT statement.
SELECT ステートメントで SQL 集計関数を指定していない場合、集計値は算出されません。
A summary value is created for each record if you include an SQL aggregate function, such as Sum or Count, in the SELECT statement.
SELECT ステートメントで、 Sum 関数や Count 関数などの SQL 集計関数 を使用すると、各レコードの集計値が得られます。
All fields in the SELECT field list must either be included in the GROUP BY clause or be included as arguments to an SQL aggregate function.
SELECT ステートメントのフィールド リストに指定したすべてのフィールドは、GROUP BY 句、または SQL 集計関数の引数のどちらかに指定する必要があります。
Unless it contains Memo or OLE Object data, a field in the GROUP BY field list can refer to any field in any table listed in the FROM clause, even if the field is not included in the SELECT statement, provided the SELECT statement includes at least one SQL aggregate function.
SELECT ステートメントに 1 つでも SQL 集計関数を指定した場合は、FROM 句に挙げたテーブルのフィールドのうち メモ型 (Memo) や OLE オブジェクト型 (OLE Object) 以外のフィールドは、SELECT ステートメントに入っていないものでも、すべて GROUP BY 句のフィールド リストに入れることができます。
However, Null values are not evaluated in any SQL aggregate function.
ただし、 Null 値は集計関数では評価されません。
Potentially sensitive or inappropriate content
Examples are used only to help you translate the word or expression searched in various contexts. They are not selected or validated by us and can contain inappropriate terms or ideas. Please report examples to be edited or not to be displayed. Potentially sensitive, inappropriate or colloquial translations are usually marked in red or in orange.