Ledger Nano X - The secure hardware wallet
SHARE
TWEET

DBMaster_ZD_T6_2

ASiwon Apr 10th, 2020 182 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT h.salesorderheaderid, h.customerid, h.orderdate
  2.   , TRUNC(MAX(h.orderdate) over (PARTITION BY h.customerid) - h.orderdate) AS days_to_lastorder1
  3.   , TRUNC(FIRST_VALUE(h.orderdate) over (PARTITION BY h.customerid ORDER BY h.orderdate DESC) - h.orderdate) AS days_to_lastorder2
  4.   FROM dbmaster.salesorderheader h
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