子句按以下顺序进行逻辑处理:(从上到下)
Updated:
面试中被问及where 和 on 的优先级,发现对 on 有盲点
① from
② on
③ where
④ group by
⑤ having
⑥ select
⑦ order by
⑧ limit
子句按以下顺序进行逻辑处理:(从上到下)
Updated:
面试中被问及where 和 on 的优先级,发现对 on 有盲点
① from
② on
③ where
④ group by
⑤ having
⑥ select
⑦ order by
⑧ limit