Having works with Group by and aggregate function. And where you can use in direct column.
For Example:
SELECT Item_Code,Item_Description,UOM
FROM Products
WHERE Item_Description like '%book%'
GROUP BY Item_Code,Item_Description,UOM
HAVING UOM = 'Each'
Hope this will help..