Guest User

Untitled

a guest
Jan 24th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Id Date
  2. 305351 1/24/2018
  3. 305351 1/23/2018
  4. E5671 10/12/2014
  5. E5671 10/11/2014
  6.  
  7. ----Retrieve days from date difference - Starts
  8. SELECT T1.EMPNO,
  9. T1.ATT_DATE
  10. FROM (
  11. SELECT T2.EMPNO, T2.ATT_DATE,
  12. ROW_NUMBER() OVER(PARTITION BY T2.EMPNO ORDER BY T2.ATT_DATE DESC) as rn
  13. FROM TableName T2
  14. ) T1
  15. WHERE T1.rn <= 2
  16. ----Retrieve days from date difference - Ends
  17.  
  18. TO_DATE(T1.ATT_DATE) - TO_DATE(T3.ATT_DATE) "DAYS"
  19.  
  20. Id Date Days
  21. 305351 1/24/2018 1
  22. 305351 1/23/2018 1
  23. E5671 10/12/2014 1
  24. E5671 10/11/2014 1
Add Comment
Please, Sign In to add comment