Advertisement
Guest User

Untitled

a guest
Jan 24th, 2017
136
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. select nvl(creation2016,to_date('01.01.2016','DD.MM.YYYY')),nvl(cnt_CREATED_ON,0), nvl(c17.creation2017,to_date('01.01.2017','DD.MM.YYYY')), nvl(cnt_CREATED_ON_1,0)
  2. from
  3. (SELECT trunc(CREATED_ON) as creation2016 , COUNT(CREATED_ON) cnt_CREATED_ON
  4. FROM 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 trunc(CREATED_ON)
  7. )c16
  8. full join
  9. (SELECT trunc(CREATED_ON) as creation2017 , COUNT(CREATED_ON) cnt_CREATED_ON_1
  10. FROM DS_HD_ISSUE_LIST_2017
  11. WHERE CREATED_ON BETWEEN /*'01.10.2016'*/ sysdate - INTERVAL '3' month AND sysdate
  12. GROUP BY trunc(CREATED_ON)
  13. )c17 on c16.creation2016 + INTERVAL '1' year = c17.creation2017
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement