I have a table with 2 rows in it.
Within the Command Line Processor, I can perform the following:
SELECT SUM(AMT) FROM TABLEA
and from the Command Line Processor, this command will result in providing the sum of the 2 rows
However, from within a JDBC connection, I only get the sum of the first tow
What can be done to resolve this ? Is this normative within JDBC