我有一个(postgresql)查询,类似于recursive account_tree as (<recursive function depending on path>), -- 1但是当我将with查询重新排序到path as (<some other query>), -- 2
recursiveaccount_tree as (<recursive function depending on path>) --
给定一个MySQL查询,该查询选择5个窗口的所有房屋:WHERE 5 = (SELECT count(*) FROM window WHERE window.house_idhouse.id我的问题是,是否对每个门执行where条件下的子查询MySQL是否足够聪明,能够意识到子查询不依赖于连接的门,因