这应该做
SELECt name, GROUP_CONCAt(fruit SEPARATOR 'n') FROM your_table GROUP BY name
db <>
fiddle中的演示
更新以添加编号：
SELECt name , GROUP_CONCAt(CONCAt (rn,')',fruit) SEPARATOR 'n')FROM ( SELECt * ,ROW_NUMBER() OVER (PARTITION BY name) AS rn FROM your_table ) SQGROUP BY name
在db <>
fiddle中编号的演示
