Hi,

How do we filter the result using WHERE and HAVING clause as used in group by

Say like...

select MAX(TaxRate) AS 'Tax Rate',StateProvinceID

from Sales.SalesTaxRate where Name <> 'Canadian GST'

group by StateProvinceID

having StateProvinceID IN (1,6,7,9)

order by StateProvinceID

Thanks for posting this..