Advertisement
Guest User

Untitled

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