[Solved] How do I group two column but return all three column value from single table
Your question is very unclear. If i understand your question correctly, this is what you want right? You didn’t mention to SUM up the values in Field3 or MAX, MIN or etc. SELECT Field1, Field2, Group_Concat(Field3) FROM tableName GROUP BY Field1 Result: Field1 Field2 Field3 a x 10, 20 b g 30, 40 c u … Read more