count

You are here: irt.org | FOLDOC | count

<programming> One of the built-in aggregate functions in relational database systems, that returns the number of rows in a result. The argument to the function is nearly always "*", e.g.

  SELECT COUNT(*) FROM books

which returns the number of rows in the "books" table. If, instead, we say

  SELECT COUNT(publisher) FROM books

then only rows with a non-null value in the "publisher" column will be counted.

(2010-09-26)

Nearby terms: COTS « Cougar « cough and die « count » countable » countably many » counted

FOLDOC, Topics, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z, ?, ALL