[sqlite] finding the groups which have some sort of mising transaction

[yuyen]

HI, all

The following 2 queries (have the same result) are about to find some groups 
which have some sort of missing transactions. Please advise which one would 
have better performance. Thank you in advance!


SELECT docketno
FROM  cntt_sales2
GROUP BY docketno
HAVING MAX(CASE WHEN datacmd = 'RCP' THEN 1 ELSE 0 END) = 0
ORDER BY docketno


SELECT docketno FROM
(SELECT docketno, MAX(case when datacmd = 'RCP' then 1 else 0 end)AS opendoc 
FROM cntt_sales2 GROUP BY docketno)
WHERE opendoc = 0


Jack