Guest User

Untitled

a guest
Jan 19th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. Customers
  2. --CustomerID
  3. --FName
  4. --SalespersonID
  5.  
  6. Salesperson
  7. --SalespersonID
  8. --FName
  9.  
  10. CustomerID -- FName -- SalespersonID
  11. 1 -- A -- 1
  12. 2 -- B -- 2
  13. 3 -- C -- 3
  14. 4 -- D -- 4
  15. 5 -- E -- 5
  16. 6 -- F -- 1
  17. 7 -- G -- 2
  18. 8 -- H -- 3
  19. 9 -- I -- 4
  20. 10 -- J -- 5
  21. 11 -- K -- 1
  22. 12 -- L -- 2
  23. 13 -- M -- 3
  24. 14 -- N -- 4
  25. 15 -- 0 -- 5
  26.  
  27. WITH с AS
  28. (
  29. SELECT *, ROW_NUMBER() OVER ORDER BY (customerID) AS rn
  30. FROM customers
  31. ),
  32. s AS
  33. SELECT *,
  34. ROW_NUMBER() OVER ORDER BY (SalespersonID) AS rn
  35. FROM salesPersons
  36. )
  37. SELECT c.*, s.*
  38. FROM с
  39. JOIN s
  40. ON s.rn =
  41. (с.rn - 1) %
  42. (
  43. SELECT COUNT(*)
  44. FROM salesPersons
  45. ) + 1
Add Comment
Please, Sign In to add comment