count
Syntax
count(X)
Arguments
X is a scalar/vector/matrix/table.
Details
size returns the number of elements in a vector or
matrix, while count
returns the number of non-NULL elements in a
vector/matrix. count
can be used in a SQL query, but
size
cannot. For tables, size
and
count
both return the number of rows.
Examples
count(3 NULL 5 6);
// output
3
size(3 NULL 5 6);
// output
4
m=1 2 3 NULL 4 5$2:3;
m;
#0 | #1 | #2 |
---|---|---|
1 | 3 | 4 |
2 | 5 |
count(m);
// output
5
size(m);
// output
6
t = table(1 NULL 3 as id, 3 NULL 9 as qty);
t;
id | qty |
---|---|
1 | 3 |
3 | 9 |
count(t);
// output
3
size(t);
// output
3