SQL · Theory

LCASE()()

Theory

144/439

LCASE()()

LCASE()() (str) is a SQL idea you prove with LCASE str on Riya's board, not with a slogan.

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

LCASE()() (str) exists so Riya can keep LCASE str on Riya's board correct in lab hour.

Riya ships LCASE()() (str) in lab hour. That is the use case worth saying.

Don’t do this with LCASE()() (str) — only reciting the name of LCASE str. Interviewers spot it in ten seconds.

After LCASE()() (str), Riya should still remember only reciting the name of LCASE str.

One breath for LCASE()() (str), then LCASE str on Riya's board, then only reciting the name of LCASE str. Sit down.

Exam tip

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

LCASE()() — sample query

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

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

Short notes

DefLCASE()() (str) — Riya uses it for LCASE str on Riya's board in lab hour.
RuleLCASE()() (str) → one LCASE str step Riya can write from memory.
RememberLCASE()() (str) + an index (lab hour).
UseLCASE()() (str) in lab hour (LCASE str on Riya's board).
TrapLCASE()() (str) — only reciting the name of LCASE str.
ExLCASE()() (str) → LCASE str on Riya's board.

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

LCASE()()

LCASE()() — sample query

Short notes

Questions

LCASE()()

LCASE()() — sample query

Short notes

Questions