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.
In a query, a function such as COUNT, AVG, or STDEV that calculates a value using all the rows in a column of a table. In writing expressions and in programming, you can use SQL aggregate functions (including the three listed above) and domain aggregate functions to determine various statistics.
An aggregate function returns a single result row, based on a group of rows. The group of rows can be an entire table or view. The aggregate functions that SQL supports are listed and described in Oracle Database SQL Language Reference.
Using the SQL aggregate functions, you can determine various statistics on sets of values. You can use these functions in a query and aggregate expressions in the SQL property of a QueryDef object or when creating a Recordset object based on an SQL query.
The expressions in the following table use SQL (Structured Query Language) functions that aggregate or summarize often see these functions (for example, Sum, Count, and Avg) referred to as aggregate functions.
You have entered an invalid argument in an aggregate function. For information on the function's arguments, see SQL Aggregate Functions, and then choose the name of the function.
In writing expressions and in programming, you can use SQL aggregate functions (including the three listed above) and domain aggregate functions to determine various statistics.
However, Null values are not evaluated in any SQL aggregate function.
ただし、 Null 値は集計関数では評価されません。
An SQL aggregate function that operates on the selected data.
選択したデータを集計する SQL 集計関数。
İçerik hassas veya uygunsuz olabilir.
Buradaki örnekler sizlere yalnızca aradığınız sözcük ve ifadeyi çevirmede yardımcı olmak için verilmiştir. Örnekler bizim tarafımızdan seçilmiş veya teyit edilmiş değildir. Mevcut örnekler uygunsuz bir dil içeriyor olabilir. Potansiyel olarak hassas, uygunsuz veya günlük konuşma dili çeviriler genellikle kırmızı ya da turuncu renkle işaretlenir.