> Le 19 f?vr. 2016 ? 07:00, admin at shuling.net a ?crit : > > 1. For all conflict records, get the total count of distinct F1 values. > In the above sample, record 1, 2, 3, 4, 5, 6 are conflict records, but the > distinct values are only 1, 2, 3 so the total count should be 3. > 2. Get the total count of all the conflict records. In the above sample, > it should be 6.
You start explaining that because the distinct values are only 1, 2, 3, the 'total count' should be 3. Then on the next line, you say wanting to get the 'total count' and say it should be 6. You lost me between those lines. :) -- Meilleures salutations, Met vriendelijke groeten, Best Regards, Olivier Mascia, integral.be/om -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 842 bytes Desc: Message signed with OpenPGP using GPGMail URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20160219/9097ad06/attachment.pgp>
