Igor Tandetnik
> select rowid, A, B, C > from t > where A||B||C in > ( select A||B||C > from t > group by A, B, C > having count(*)>1 > );Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be duplicate of ('x', 'yz', 'w') ? Igor Tandetnik
Due the fact that, in this case, the columns are integers, can be done some trickery in the concatenation to avoid that?
Some like: A||'*'||B||'*||C ? A.J.Millan ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
