SHARE
TWEET

Untitled

a guest Feb 27th, 2020 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT Trunc(booking_date), Count(1) AS cnt
  2. -- SELECT *
  3.   FROM AcmVoucher v
  4.   JOIN AcmVoucherType vt
  5.     ON v.voucher_type_id = vt.id
  6.  WHERE v.erp_target_1 = 0
  7.    AND v.voucher_state_id=1000
  8.    AND BITAND(vt.flags, 2) = 0
  9. GROUP BY Trunc(booking_date)
  10. ORDER BY Trunc(booking_date)
  11. SELECT Trunc(booking_date), Count(1) AS cnt
  12. -- SELECT *
  13.   FROM AcmVoucher v
  14.   JOIN AcmVoucherType vt
  15.     ON v.voucher_type_id = vt.id
  16.  WHERE v.erp_target_1 = 0
  17.    AND v.voucher_state_id=1000
  18.    AND BITAND(vt.flags, 2) = 0
  19. GROUP BY Trunc(booking_date)
  20. ORDER BY Trunc(booking_date)
  21. SELECT Trunc(booking_date), Count(1) AS cnt
  22. -- SELECT *
  23.   FROM AcmVoucher v
  24.   JOIN AcmVoucherType vt
  25.     ON v.voucher_type_id = vt.id
  26.  WHERE v.erp_target_1 = 0
  27.    AND v.voucher_state_id=1000
  28.    AND BITAND(vt.flags, 2) = 0
  29. GROUP BY Trunc(booking_date)
  30. ORDER BY Trunc(booking_date)
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