Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. WITH GCD AS(
  2. SELECT a, b, a as origA, b as origB,ida,idb
  3. FROM (
  4. SELECT weight as a,name as ida
  5. FROM DISHES
  6. ) ab
  7. CROSS JOIN (SELECT weight as b,name as idb FROM DISHES)b
  8. UNION ALL
  9. SELECT b,a%b,origA,origB,ida,idb
  10. FROM GCD
  11. WHERE b > 0
  12. )
  13. SELECT ida as FName, OrigA as FWeight, idb as SDishname, OrigB as SWeight,
  14. CASE WHEN origA/a*origB >=1488
  15. THEN origA/a*origB/a
  16. ELSE origA/a*origB
  17. END AS NOK, a as NOD
  18. FROM GCD
  19. WHERE b = 0 AND ida!=idb
  20. ORDER BY origA,origB,a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement