每日一题，活动脑筋

[wsaaaa]

关于 SQL 查询的执行顺序，正确的是（）
A. SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY
B. FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY
C. FROM → GROUP BY → WHERE → HAVING → SELECT → ORDER BY
D. FROM → WHERE → SELECT → GROUP BY → HAVING → ORDER BY

[独善其身]

这个问法还是第一次见啊

[LNH]

正确答案是B吧

[ljware]

我选B，先找表，再过滤行，再分组，再筛选分组，再选择字段，最后排序

[DonACE]

B. FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY

[AntTech_UABXCS]

点赞

[忙碌了两个小时的陈师傅]

这个问题问的好

[wkk2025]

666

[小智0324]

选B吧，按道理应该是这么选

[牛马]

应该是先找到目标表–b

[jxnxsly]

@论坛小助手 回答下

[论坛小助手]

您好，您提到的问题似乎与 OceanBase 没有关联，我无法回答，敬请谅解! 如果您有其他 OceanBase 相关问题，欢迎继续提问。

[longzh85]

选b