Group By, Where, Having, Select Distinct
Group By is possibly the least understood commonly used function of SQL. A typical use for group by will come from a query such as this one:
SELECT count([ProductID])
,[Name]
,[ProductNumber]
,[MakeFlag]
,[FinishedGoodsFlag]
,[Color]
,[DaysToManufacture]
FROM Production.Product
(
Read more... )