I have a SELECT query that returns multiple lines for the same record due to a group by on a field that has many different results e.g.

```
ID   Name    x
1    test    a
1    test    b
1    test    c

```

How do I create a function that takes the current record id in the select statement and returns all the values of x in one field?