Urgent !! Online etc., different from the past (with a certain challenge coefficient), how to use sql to merge rows into

chch1101199

Column name 1, column name 2
    A, 1
    A, 2
    A, 3
    .
    .
    .
    A, x

Then what statement method can be achieved
 Column name 1, column name 2
    A, 1; 2; 3 ... x

I hope the heroes will help out soon

8307519

Don't understand your statement
Or there are only 2 columns, what does 1;2;3...x mean?
Is it 1;2;3...x column? Or does "Column Name 2" have 1;2;3...x?

chch1101199

It is like this: there are two columns, the number of rows is uncertain, the final result is to find the row with A, and then combine the column names by ";" to form a row