Guest User

Untitled

a guest
May 24th, 2018
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. OFFICECODE | DATE | VAL
  2. 10200 | 2018-05-01 | 1
  3. 10200 | 2018-05-02 | 2
  4. 10100 | 2018-05-01 | 3
  5. 10100 | 2018-05-02 | 2
  6.  
  7. OFFICECODE | DATE | SUM(VAL)
  8. 10200 | 2018-05-01 | 1
  9. 10200 | 2018-05-02 | 3 (1+2)
  10. 10100 | 2018-05-01 | 3
  11. 10100 | 2018-05-02 | 5 (3+2)
  12.  
  13. SELECT
  14. A.OFFICELKD,
  15. A.DATE,
  16. A.VAL,
  17. @VAL := @VAL + A.VAL AS `VALSUM`
  18. FROM
  19. ( SELECT
  20. cur.OFFICELKD,
  21. cur.DATE,
  22. cur.VAL
  23. FROM
  24. tblReport cur
  25. LEFT JOIN
  26. tblReport pre
  27. ON cur.OFFICECODE = pre.OFFICECODE
  28. GROUP BY cur.ID
  29. ORDER BY
  30. OFFICECODE ) AS A,
  31. ( SELECT @VAL := 0 ) AS SqlA
  32. ORDER BY OFFICECODE, DATE
Add Comment
Please, Sign In to add comment