I have this data in a single table:

```
ID      ANIMAL
555000  Dog
555000  Cow
555000  Fox
657000  Fox
817900  Dog
817900  Fox
829800  Fox
830300  Fox
830600  Fox
830800  Fox
831100  Dog
831100  Fox
839900  Fox

```

I need to create output that groups by the ID and then creates a delimited string of the Id's animals. Given the data above, I need the following output. Note, each ID should be an individual row in the resultset and the animals should be concatenated into a single string for each ID. I'm not looking to create one large concatenated string.

```
555000  Dog<br/>Cow<br/>Fox
657000  Fox
817900  Dog<br/>Fox
829800  Fox
830300  Fox
830600  Fox
830800  Fox
831100  Dog<br/>Fox
839900  Fox

```

Here is the SQL I have so far. It produces a row for each ID, ANIMAL combination. The problem is the values in ANIMAL field are not being concatenated. What am I doing wrong?

```
select ID,
        REPLACE (wm_concat (DISTINCT ANIMAL),',','<br/>')
from TheTable
group by ID, ANIMAL

```