Advertisement
Guest User

Untitled

a guest
Oct 17th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. SELECT * FROM tmp_StatCPRBunker_lohe
  2. UNPIVOT ( BUNKE_COUNT FOR BUNKE_ID IN ( bunke_id_4032,
  3. bunke_id_4070,
  4. bunke_id_4205,
  5. bunke_id_4206,
  6. bunke_id_4207,
  7. bunke_id_4208,
  8. bunke_id_4209,
  9. bunke_id_4210,
  10. bunke_id_4211,
  11. bunke_id_4212,
  12. bunke_id_4213,
  13. bunke_id_4214,
  14. bunke_id_4215,
  15. bunke_id_4216,
  16. bunke_id_4217,
  17. bunke_id_4218,
  18. bunke_id_4219,
  19. bunke_id_4220,
  20. bunke_id_4221,
  21. bunke_id_4222,
  22. bunke_id_4223,
  23. bunke_id_4224,
  24. bunke_id_4225,
  25. bunke_id_4226,
  26. bunke_id_4227,
  27. bunke_id_4228,
  28. bunke_id_4234,
  29. bunke_id_4237,
  30. bunke_id_4238,
  31. bunke_id_4239,
  32. bunke_id_4240,
  33. bunke_id_4241,
  34. bunke_id_4242,
  35. bunke_id_4243,
  36. bunke_id_4260,
  37. bunke_id_4261))
  38. PIVOT(count(bunke_count) for employee (pipo,jeje,siat,doje))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement