I can't because I need the max from and to dates that when summed do not equal 0. This is my current SQL, but I can't figure out how to choose the max from and to date row.<br><br>SELECT A.BILL_TO_CUST_ID,TO_CHAR(A.FROM_DT,'YYYY-MM-DD'),<br>TO_CHAR(A.TO_DT,'YYYY-MM-DD'),SUM(...
Am trying to get the max date from a table where the sum of the rows <> 0. ie<br>Datatable<br>CU From To SUM(Amt)<br>15255 2000-01-01 2000-03-31 12.00<br>15255 1999-10-01 1999-12-31 7,031.00<br>15255 1999-07-01 1999-09-30...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.