The query above contains a correlated subquery, since the main query and the subquery are relaying on the same table, the employees table.
以上查询包含一个相关子查询,因为主查询和子查询依靠于同一个表,即employees表。
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.
与表4中的数据相联系,可以指示数据库服务器是系统中最少使用的构件,数据库通道也可以提供最高层次的性能。
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.
SQL 表函数中的 MODIFIES SQL DATA 使您甚至可以将 INSERT、UPDATE、DELETE 和 MERGE ( 数据更改操作)放入到关联连接的内表中。
应用推荐