Advertisement
Guest User

Untitled

a guest
Mar 24th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. PRODUCT
  2. id some_column
  3. 1 10
  4. 2 2
  5. 3 8
  6.  
  7. COMPARISION
  8. id product_left product_right result
  9. 1 1 2 3
  10. 2 1 3 8
  11. 3 2 3 2
  12.  
  13. SELECT * FROM COMPARISION WHERE ( product_left = 1 OR product_right = 1 ) ORDER BY result DESC LIMIT n
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement