SQL · Theory

RTRIM()()

Theory

165/439

RTRIM()()

Don’t start RTRIM()() (str) with jargon. Start with a RTRIM str dry-run. That is the whole point.

RTRIM()() (str) on the board: one RTRIM str step Riya can write from memory. Then say what a RTRIM str dry-run looks like after.

RTRIM()() (str) exists so Riya can keep a RTRIM str dry-run correct in a small live site.

RTRIM()() (str) shows up in a small live site. Name a RTRIM str dry-run, not “a real-world scenario”.

If a RTRIM str dry-run breaks under RTRIM()() (str), check only reciting the name of RTRIM str first.

Place RTRIM()() (str) next to nearby SQL work — one RTRIM str step Riya can write from memory is the link.

Close RTRIM()() (str) with: “If I skip it, a RTRIM str dry-run goes wrong like this: only reciting the name of RTRIM str.”

Exam tip

Say RTRIM()() (str) in one breath, then one RTRIM str step Riya can write from memory, then only reciting the name of RTRIM str.

RTRIM()() — sample query

-- RTRIM()()
CREATE TABLE demo (
  id INTEGER PRIMARY KEY,
  label TEXT NOT NULL,
  qty INTEGER DEFAULT 0
);
INSERT INTO demo (id, label, qty) VALUES
  (1, 'alpha', 2),
  (2, 'beta', 5);
SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

RTRIM()(): create two demo rows, then SELECT qty >= 2 ordered. Say which labels come back.

Short notes

DefRTRIM()() (str) — Riya uses it for a RTRIM str dry-run in a small live site.
RuleRTRIM()() (str) → one RTRIM str step Riya can write from memory.
RememberRTRIM()() (str) + the query planner (a small live site).
UseRTRIM()() (str) in a small live site (a RTRIM str dry-run).
TrapRTRIM()() (str) — only reciting the name of RTRIM str.
ExRTRIM()() (str) → a RTRIM str dry-run.

-- RTRIM()() CREATE TABLE demo ( id INTEGER PRIMARY KEY, label TEXT NOT NULL, qty INTEGER DEFAULT 0 ); INSERT INTO demo (id, label, qty) VALUES (1, 'alpha', 2), (2, 'beta', 5); SELECT label, qty FROM demo WHERE qty >= 2 ORDER BY qty DESC;

RTRIM()()

RTRIM()() — sample query

Short notes

Questions

RTRIM()()

RTRIM()() — sample query

Short notes

Questions