things to remember

• instead of "limit 6", use "WHERE rownum<=6"

pseudocolumns

• rownum — used to do the effect of "LIMIT 1"
• rowid — used to do back-to-back SELECT and UPDATE statements, by tying the rows together with a silver-bullet method