SQL · Theory

RAND()()

← All stacks

Theory

211/439

RAND()()

RAND()() (math) sits in a campus project. Rohit’s job is RAND math on Rohit's board. Write that first.

For RAND()() (math), an index is in play. Don’t blame it until you have traced RAND math on Rohit's board.

RAND()() (math) exists so Rohit can keep RAND math on Rohit's board correct in a campus project.

Use RAND()() (math) when RAND math on Rohit's board must stay clear. If a simpler SQL step works, use that instead.

RAND()() (math) miss — skipping the failure case for RAND math. Fix it before you talk about advanced SQL.

After RAND()() (math), Rohit should still remember skipping the failure case for RAND math.

Viva for RAND()() (math): what it is → one RAND math step Rohit can write from memory → the mistake (skipping the failure case for RAND math).

Exam tip

Board: RAND math on Rohit's board. Dry-run RAND()() (math). Name the trap: skipping the failure case for RAND math.

RAND()() — sample query

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

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

Short notes

DefRAND()() (math) — Rohit uses it for RAND math on Rohit's board in a campus project.
RuleRAND()() (math) → one RAND math step Rohit can write from memory.
RememberRAND()() (math) + an index (a campus project).
UseRAND()() (math) in a campus project (RAND math on Rohit's board).
TrapRAND()() (math) — skipping the failure case for RAND math.
ExRAND()() (math) → RAND math on Rohit's board.

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

RAND()()

RAND()() — sample query

Short notes

Questions

RAND()()

RAND()() — sample query

Short notes

Questions