- 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...
-
CREATE TABLE comments ( content VARCHAR ( 100 ), created_at TIMESTAMP DEFAULT NOW () ); INSERT INTO comments ( content ) V...
-
CODE: Setting Default Values Define a table with a DEFAULT name specified: CREATE TABLE cats3 ( name VARCHAR ( 20 ) DEFAUL...
-
SELECT author_fname , author_lname FROM books ; CONCAT ( x , y , z ) // from slides CONCAT ( column , anotherColumn ) // from ...
No comments:
Post a Comment