Sunday, February 23, 2020

Logical: NOT EQUAL

  1. SELECT title FROM books WHERE released_year = 2017;
  2.  
  3. SELECT title FROM books WHERE released_year != 2017;
  4.  
  5. SELECT title, author_lname FROM books;
  6.  
  7. SELECT title, author_lname FROM books WHERE author_lname = 'Harris';
  8.  
  9. SELECT title, author_lname FROM books WHERE author_lname != 'Harris';

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...