Interview question

Question

Today i have faced a interview question.

input:

id units

1 100

2 200

1 400

3 800

output:

id units

1 100,400

2 200

3 800

Please help me to write a query with select statement?