From: "raistware" <[email protected]> > 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)
