[sqlite] Re: A beginner SQL question

[Igor Tandetnik]

Simon Davies
<simon.james.davies-gM/[EMAIL PROTECTED]> wrote:
I use:
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 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------