- SELECT
- title,
- author_lname,
- released_year
- FROM books
- WHERE author_lname='Eggers' || released_year > 2010;
- SELECT 40 <= 100 || -2 > 0;
- -- true
- SELECT 10 > 5 || 5 = 5;
- -- true
- SELECT 'a' = 5 || 3000 > 2000;
- -- true
- SELECT title,
- author_lname,
- released_year,
- stock_quantity
- FROM books
- WHERE author_lname = 'Eggers'
- || released_year > 2010
- OR stock_quantity > 100;
Sunday, February 23, 2020
Logical: OR
Subscribe to:
Post Comments (Atom)
Right Joins
-- OUR FIRST RIGHT JOIN (seems the same as a left join?) SELECT * FROM customers RIGHT JOIN orders ON customers.id = orders.custom...
-
CODE: Primary Keys Define a table with a PRIMARY KEY constraint: CREATE TABLE unique_cats ( cat_id INT NOT NULL , name ...
-
CODE: Setting Default Values Define a table with a DEFAULT name specified: CREATE TABLE cats3 ( name VARCHAR ( 20 ) DEFAUL...
-
SELECT MIN ( released_year ) FROM books ; SELECT MIN ( released_year ) FROM books ; SELECT MIN ( pages ) FROM books ; SELE...
No comments:
Post a Comment