在没有Cursor的单个SQL表中合并数据

I have a table with an ID column and another column with a number. One ID can have multiple numbers. For exampleI have a table with an ID column and another co