22
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
24
SELECT COUNT * FROM Nodes
27
27
In the above statement, the COUNT keyword returns the number 3, because the user Smith has 3 total nodes.
29
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: ::