SQL
WHERE and Comparison Operators
WHERE decides which rows survive. Learn the comparison operators, how conditions are evaluated per row, and why a function around a column kills an in...
WHERE
Filtering rows with comparison and logical operators, IN, BETWEEN, LIKE and IS NULL.
3 notes
Notes
SQL
AND, OR, NOT and Operator Precedence
Combining conditions correctly. Precedence between AND and OR, what NOT does to a NULL, and how to keep complex filters readable and index friendly.
SQL
IN, BETWEEN, LIKE and IS NULL
The four filtering shortcuts you will use constantly: set membership, ranges, pattern matching with wildcards, and the only correct way to test for NU...