Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT
  2. SUM(quantity) AS qt
  3. FROM
  4. stockMove
  5. WHERE
  6. date_mov >= '2019-04-01'
  7. AND
  8. date_mov <= '2019-04-30'
  9. AND
  10. ProductCode = '000807'
  11. GROUP BY
  12. ProductCode
  13.  
  14. SELECT COALESCE(SUM(quantity),0) AS qt
  15.  
  16. SELECT COALESCE(SUM(quantity), 0) AS qt
  17. FROM stockMove
  18. WHERE date_mov >= '2019-04-01' AND date_mov <= '2019-04-30' AND
  19. ProductCode = '000807';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement