SHARE
TWEET

Untitled

a guest Jun 17th, 2019 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Cuota  DateCuota  DatePaid   Capital  Interest  Status
  2. ------  ----------  ----------  -------  -------  --------
  3.      1  2018-05-07  2018-05-07  722.62   265.78         -1
  4.      2  2018-06-06  2018-06-06  741.67   246.73         -1
  5.      3  2018-07-06  2018-07-07  768.64   219.76         -1
  6.      4  2018-08-05  2018-07-07  2305.92  400.00         -1
  7.      5  2018-09-04  2018-07-07  5543.42  646.63         -1
  8.      
  9. SELECT IFNULL (SUM (Interest), 0) Interest FROM detailpre WHERE DateQuota <= '2018-06-30'
  10.      
  11. SELECT IFNULL (SUM (Interest), 0) Interest FROM detailpre WHERE DateQuota <= '2018-07-30'
  12.      
  13. SELECT IFNULL (SUM (Interest), 0) Interest FROM detailpre WHERE DateQuota <= '2018-08-30'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top