SQL · Theory

BETWEEN

Theory

58/439

BETWEEN

BETWEEN sits in a first job task. Arun’s job is BETWEEN on Arun's board. Write that first.

BETWEEN on the board: one BETWEEN step Arun can write from memory. Then say what BETWEEN on Arun's board looks like after.

Without BETWEEN, a first job task gets messy and BETWEEN on Arun's board is hard to trust.

Arun ships BETWEEN in a first job task. That is the use case worth saying.

If BETWEEN on Arun's board breaks under BETWEEN, check skipping the failure case for BETWEEN first.

BETWEEN is not a lonely heading. Arun ties it to BETWEEN on Arun's board.

Close BETWEEN with: “If I skip it, BETWEEN on Arun's board goes wrong like this: skipping the failure case for BETWEEN.”

Exam tip

Board: BETWEEN on Arun's board. Dry-run BETWEEN. Name the trap: skipping the failure case for BETWEEN.

BETWEEN — sample query

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL);
INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50);
SELECT * FROM products
WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

BETWEEN — wHERE combines predicates with AND/OR; LIKE does pattern match.

Short notes

DefBETWEEN — Arun uses it for BETWEEN on Arun's board in a first job task.
RuleBETWEEN → one BETWEEN step Arun can write from memory.
RememberBETWEEN + an index (a first job task).
UseBETWEEN in a first job task (BETWEEN on Arun's board).
TrapBETWEEN — skipping the failure case for BETWEEN.
ExBETWEEN → BETWEEN on Arun's board.

CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT, price REAL); INSERT INTO products VALUES (1, 'Pen', 10), (2, 'Book', 200), (3, 'Bag', 50); SELECT * FROM products WHERE price BETWEEN 20 AND 150 AND name LIKE 'B%';

BETWEEN

BETWEEN — sample query

Short notes

Questions

BETWEEN

BETWEEN — sample query

Short notes

Questions