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

On Thu, 20 Jul 2006 15:44:32 +1000, you wrote: >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! Why not measure both cases with:

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

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 =