Hi,
A simple group by function should work for this:
Select Fruit,GrownInStates From tbl1 Group By Fruit;
and if you want grownstates in comma separated format then you can use
Group_Concat function
Select Fruit, Group_Concat(GrownInStates, SEPARATOR ',') From tbl1
Group By Fruit;
Hope th
Hi,
I'm very new to SQL and databases. I need a query for the following: (I'm sure
google would have found the answer, but I could not really frame the sentence
for the task I'm looking for. Also, please let me know how do I search in
google for such tasks - so that I can try it myself in fut
