Re: [sqlite] multi threading

[Cosmin Vlasiu]

yes it is illegal, cause I've copy/paste then I adapt
by replacing th name of table, i've extract irrelevant info
and I forgot the "and"
but, your statement it's very well
thanks and regards
----- Original Message ----- 
From: "Kurt Welgehausen" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Sunday, April 17, 2005 11:20 PM
Subject: Re: [sqlite] multi threading


SELECT  id, code FROM a WHERE
    (code IN
        (SELECT code FROM
                (SELECT code, COUNT(code) AS c FROM  a GROUP BY code) AS 
aaa
WHERE  c > 1)
        )
   and ORDER BY code
The "and" in your code is illegal, but it is better to use
 select id, code from a
 where code in
   (select code from a group by code having count(code) > 1)
 order by code
Regards