I have a use case that imply returning all the records even if the same id is specified many times

```
select d.id from data d where d.id in (1420552,  1420553)
union all
select d.id from data d where d.id in (1420552, 1420553)

```

As the "IN" predicate is just translated as an "OR" between all the specified values it will not give me the desired result.

```
select d.id from data d where d.id in (1420552,  1420553, 1420552, 1420553)

```

Therefore i'm wondering if there is any alternative to get the desired result.
Thank you in advance.

[![enter image description here](https://i.stack.imgur.com/jXORm.png)](https://i.stack.imgur.com/jXORm.png)