Group By is like Distinct

CREATE TABLE DistinctItemCombos
SELECT ItemA, ItemB, ItemC, ItemD
FROM {SomeTable}
GROUP BY ItemA, ItemB, ItemC, ItemD

Will group ItemA, ItemB, ItemC, ItemD, and hence only show 1 type of ItemA.