Aggregate functions (Linear Regression) , Window function syntax and usage
Returns the number of non-null number pairs in a group.
Syntax¶Aggregate function
Window function
REGR_COUNT(y, x) OVER ( [ PARTITION BY <expr3> ] )
Copy
Arguments¶y
The dependent variable. This must be an expression that can be evaluated to a numeric type.
x
The independent variable. This must be an expression that can be evaluated to a numeric type.
expr3
This is the optional expression used to group rows into partitions.
Important
Note the order of the arguments; the dependent variable is first.
Usage notes¶DISTINCT is not supported for this function.
When this function is called as a window function, it does not support:
An ORDER BY clause within the OVER clause.
Explicit window frames.
Show the number of pairs in each group, and the number of those pairs in which neither member is NULL.
CREATE OR REPLACE TABLE aggr(k INT, v DECIMAL(10,2), v2 DECIMAL(10, 2)); INSERT INTO aggr VALUES(1, 10, null); INSERT INTO aggr VALUES(2, 10, 11), (2, 20, 22), (2, 25, null), (2, 30, 35); SELECT k, COUNT(*), REGR_COUNT(v, v2) FROM aggr GROUP BY k;
Copy
+---+----------+-------------------+ | k | count(*) | regr_count(v, v2) | |---+----------+-------------------| | 1 | 1 | 0 | | 2 | 4 | 3 | +---+----------+-------------------+
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4