Tuesday, 6 March 2012

Using COUNT() function

SELECT COUNT(Product) AS ProductMilk FROM Product
WHERE Product='Milk'


It will count no of bottles of milk

No comments:

Post a Comment