TABLE XYZ has cols id,item_name,type
with the following data
from this table if i just wanted to return one item for each type how would i do it?
looking for some output like
the item_name that is returned does not matter