Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. fnrvon fnran prozent
  2. ----------- ----------- -----------
  3. 101 102 5.25
  4. 101 103 15.75
  5. 101 104 0.00
  6. 101 105 0.00
  7. 101 106 0.00
  8. 101 107 0.00
  9. 102 101 5.50
  10. 102 103 10.50
  11. 102 104 0.00
  12. 102 105 0.00
  13. 102 106 0.00
  14. 102 107 0.00
  15. ........
  16.  
  17. select * from rabatt r1 cross join rabatt r2;
  18.  
  19. select distinct r1.fnrvon, r2.fnran
  20. from rabatt r1
  21. cross join rabatt r2
  22. where r1.fnrvon != r2.fnran
  23. order by r1.fnrvon;
  24.  
  25. SELECT f1.fnr AS 'from', f2.fnr AS 'to', COALESCE(r.prozent, 0)
  26. FROM firma f1
  27. CROSS JOIN firma f2
  28. LEFT JOIN rabatt r ON r.fnrvon = f1.fnr AND r.fnran = f2.fnr
  29. WHERE f1.fnr != f2.fnr
  30. ORDER BY f1.fnr, f2.fnr;
  31.  
  32. SELECT fnrvon FROM rabatt UNION SELECT fnran FROM rabatt;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement