SQL COUNT Function
COUNT (*) returns the number of rows satisfying given conditions.
For example:
SELECT COUNT (*)
FROM SecA_Bal
WHERE Balance >0;
This query will return the answer 3, the number fo rows which have a balance greater than 0, or the number of customers in SecA_Bal owin money.
COUNT (*) returns the number of rows satisfying given conditions.
For example:
SELECT COUNT (*)
FROM SecA_Bal
WHERE Balance >0;
This query will return the answer 3, the number fo rows which have a balance greater than 0, or the number of customers in SecA_Bal owin money.
