The query above contains a correlated subquery, since the main query and the subquery are relaying on the same table, the employees table.
以上查询包含一个相关子查询，因为主查询和子查询依靠于同一个表，即employees表。
2
Correlated with the data in Table 4, which indicates that the database server is the least-used component in the system, either database vendor will provide the highest level of performance.
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.