Question Preston Exley · May 27, 2021 JDBC counts don't match I'm using a JDBC driver to connect PGSQL -> Cache. I'm noticing when I run SELECT queries and COUNT(*) command against the same table, I get different result sets. I'm pretty new to Cache in general - so I'm trying to understand why these would be different. Examples (TransID and InvNum should occur in every "row"): SELECT COUNT(*) FROM ACCT.Services = 1,090,324 WHERE ACCT.Dept = 483 SELECT TransID FROM ACCT.Services = 1,085,776 WHERE ACCT.Dept = 483 SELECT InvNum FROM ACCT.Services = 586,023 WHERE ACCT.Dept = 483 #JDBC #SQL #Caché 0 8 0 247