Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2017
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. SELECT to_char(DATE_,'dd-mm') as daymonth FROM work_days
  2. JOIN
  3. (SELECT to_char(CREATED_ON,'dd-mm') as creation2016, COUNT(CREATED_ON)
  4. FROM cuba.DS_HD_ISSUE_LIST_2017
  5. WHERE CREATED_ON BETWEEN /*'01.10.2015'*/sysdate - INTERVAL '15' month AND (sysdate - INTERVAL '1' year)
  6. GROUP BY to_char(CREATED_ON,'dd-mm'))
  7. creation2016 on creation2016.creation2016 = work_days.daymonth
  8. JOIN ( SELECT to_char(CREATED_ON,'dd-mm') as creation2017
  9. FROM cuba.DS_HD_ISSUE_LIST_2017
  10. WHERE CREATED_ON BETWEEN /*'01.10.2016'*/ sysdate - INTERVAL '3' month AND sysdate
  11. GROUP BY to_char(CREATED_ON,'dd-mm'))
  12. creation2017 on creation2017.creation2017 = work_days.daymonth;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement