-
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;