While this is not a huge deal, I'm just wondering if this is possible (I'm using MySQL in case that matters).
I have a query that returns something like this:
Basket Contents basket1 apple basket1 orange basket1 pear basket2 lemon basket2 banana basket2 lime
Is it possible using only SQL to get this output?
Basket Contents basket1 apple orange pear basket2 lemon banana lime
In other words, is it possible to list the column entry only once for each entry? Thank you.