19
19
|6 |10/2/2010 |820 |4 |Smith |
20
20
+--------+-------------------+------------+----------------+-------------------+
22
The SQL COUNT function returns the number of rows in a table satisfying the criteria specified in the WHERE clause. If we want to count how many orders has made a customer with CustomerName of Smith, we will use the following SQL COUNT expression: ::
22
The SQL COUNT function returns the number of rows in a table satisfying the criteria specified in the WHERE clause. If we want to count how many orders has made a customer with CustomerName of Smith, we will use the following SQL COUNT expression:
24
26
SELECT COUNT * FROM Nodes
25
27
WHERE UserName = "Smith";
27
29
In the above statement, the COUNT keyword returns the number 3, because the user Smith has 3 total nodes.
29
If you don’t specify a WHERE clause when using the COUNT keyword, your statement will simply return the total number of rows in the table, which would be 6 in this example: ::
31
If you don’t specify a WHERE clause when using the COUNT keyword, your statement will simply return the total number of rows in the table, which would be 6 in this example:
31
35
SELECT COUNT * FROM Nodes;
added
removed
docs/functions/count.rst
