Ive seen it used but never used it myself. I did have the need to use it today!
Input
SELECT COUNT(*) AS num_cust
FROM Customers
Results num_cust ----------- 5
Analysis
In the example above, Count(*) is used to count all roes, regardless of values. The count is returned in num_cus
My select statement:
SELECT count(cus_cd)
FROM dbo.customer
WHERE (cus_status = 'A')
I returned the number of active customers
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment