- SELECT title, released_year FROM books;
- SELECT title, released_year FROM books
- WHERE released_year < 2000;
- SELECT title, released_year FROM books
- WHERE released_year <= 2000;
- SELECT 3 < -10;
- -- false
- SELECT -10 < -9;
- -- true
- SELECT 42 <= 42;
- -- true
- SELECT 'h' < 'p';
- -- true
- SELECT 'Q' <= 'q';
- -- true
Sunday, February 23, 2020
Logical: LESS THAN
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