SHARE
TWEET

Untitled

a guest Jun 25th, 2019 60 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. +--------+------------+
  2. | emp_id | pre_date   |
  3. +-----------+---------+
  4. | 002    | 2019-04-01 |
  5. | 001    | 2019-04-21 |
  6. | 001    | 2019-04-15 |
  7. | 001    | 2019-04-19 |
  8. | 002    | 2019-04-15 |
  9. | 002    | 2019-04-16 |
  10. | 002    | 2019-04-10 |
  11. | 001    | 2019-04-10 |
  12. | 001    | 2019-04-20 |
  13. | 002    | 2019-04-19 |
  14. | 001    | 2019-04-01 |
  15. | 001    | 2019-04-30 |
  16. | 002    | 2019-04-21 |
  17. | 002    | 2019-04-24 |
  18. | 001    | 2019-04-16 |
  19. | 002    | 2019-04-20 |
  20. | 001    | 2019-04-24 |
  21. +-----------+---------+
  22.      
  23. +--------+------------+
  24. | emp_id | count      |
  25. +-----------+---------+
  26. | 001    |3           |
  27. +-----------+---------+
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