Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  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'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement