News for hackers. Stuff that matters.

A comment on An UPDATE without a WHERE, or something close to it. Parent comment

Re:An UPDATE without a WHERE, or something close to it by masklinn on Friday October 29, 2021 @03:23PM (#29042534)
> In select, the actual SELECT clause (field selection) can usually be conceptualized as “happening” after all other clauses

Not quite true, DISTINCT, ORDER BY and TOP/LIMIT happen afterwards.

[ Parent | on HN ]
Re:An UPDATE without a WHERE, or something close to it by hermanradtke on Friday October 29, 2021 @04:44PM (#29043313)
Also, HAVING
[ Parent | on HN ]