From: "raistware" <raul.ferriz@...>

> Hi
>
> Im trying a bit difficult select:
>
> select id, value
> from MyTable
> where id in (1, 1, 1, 2, 3, 3, 4)
>

Try:

select DISTINCT id, value
from MyTable
where id in (1, 1, 1, 2, 3, 3, 4)


Although, I fail to see the reasoning behind duplicates of the same number
in the IN clause. They should be stripped out before passing the query in
your code.

HTH
Woody (TMW)