SQL · Theory

last()

← All stacks

Theory

125/439

last()

If you can teach last() using a last dry-run, you know it. If you only know the heading, you don’t.

Do last() once by hand. one last step Sara can write from memory. Change one input. Say the new result out loud.

Skip last() and only reciting the name of last shows up in a first job task.

last() shows up in a first job task. Name a last dry-run, not “a real-world scenario”.

last() trap — only reciting the name of last. Sara loses marks for that every viva.

Place last() next to nearby SQL work — one last step Sara can write from memory is the link.

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

Exam tip

Say last() in one breath, then one last step Sara can write from memory, then only reciting the name of last.

last() — sample query

-- last()
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;

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

Short notes

Deflast() — Sara uses it for a last dry-run in a first job task.
Rulelast() → one last step Sara can write from memory.
Rememberlast() + an index (a first job task).
Uselast() in a first job task (a last dry-run).
Traplast() — only reciting the name of last.
Exlast() → a last dry-run.

-- last() 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;

last()

last() — sample query

Short notes

Questions

last()

last() — sample query

Short notes

Questions