-
SQL is written in statements that ask the database to perform many things.
-
SQL talks to the database.
SELECT name, author FROM books WHERE ratings > 10;
| = | equal | less or equal | |
| > | greater than | not equal | |
| less than | != | not equal | |
| >= | greater or equal | BETWEEN | between two values |
| IN | in a list | NOT IN | not in a list |
SELECT name, author FROM books WHERE ratings BETWEEN 5 AND 10;