- SELECT title FROM books WHERE released_year = 2017;
- SELECT title FROM books WHERE released_year != 2017;
- SELECT title, author_lname FROM books;
- SELECT title, author_lname FROM books WHERE author_lname = 'Harris';
- SELECT title, author_lname FROM books WHERE author_lname != 'Harris';
Sunday, February 23, 2020
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