Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH GCD AS(
- SELECT a, b, a as origA, b as origB,ida,idb
- FROM (
- SELECT weight as a,name as ida
- FROM DISHES
- ) ab
- CROSS JOIN (SELECT weight as b,name as idb FROM DISHES)b
- UNION ALL
- SELECT b,a%b,origA,origB,ida,idb
- FROM GCD
- WHERE b > 0
- )
- SELECT ida as FName, OrigA as FWeight, idb as SDishname, OrigB as SWeight,
- CASE WHEN origA/a*origB >=1488
- THEN origA/a*origB/a
- ELSE origA/a*origB
- END AS NOK, a as NOD
- FROM GCD
- WHERE b = 0 AND ida!=idb
- ORDER BY origA,origB,a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement