Sunday, February 23, 2020

Logical: OR

  1. SELECT
  2. title,
  3. author_lname,
  4. released_year
  5. FROM books
  6. WHERE author_lname='Eggers' || released_year > 2010;
  7.  
  8.  
  9. SELECT 40 <= 100 || -2 > 0;
  10. -- true
  11.  
  12. SELECT 10 > 5 || 5 = 5;
  13. -- true
  14.  
  15. SELECT 'a' = 5 || 3000 > 2000;
  16. -- true
  17.  
  18. SELECT title,
  19. author_lname,
  20. released_year,
  21. stock_quantity
  22. FROM books
  23. WHERE author_lname = 'Eggers'
  24. || released_year > 2010
  25. OR stock_quantity > 100;

No comments:

Post a Comment

Right Joins

-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders     ON customers.id = orders.custom...