Note: These parameters count in the NUMBER of parameters clause but they do not appear as parameters of the federated procedure.
注：NUMBEROFparameters子句中考虑这些参数，但是它们不作为联邦过程的参数出现。
The LIMIT clause is helpful when you want to limit the number of records returned by an SQL statement.
想要限制一个SQL 语句返回的记录数，可以使用 LIMIT 子句。
Usage: This parameter controls the decision on whether or not to apply a NON EMPTY clause on member requests when the number of tuples exceeds the set threshold.
用法：当元组数超过设定的阈值时，该参数控制是否对成员请求应用NONempty子句的决策。
The following example shows a SELECT statement with a hierarchical query clause to return all direct subordinates for the manager Meier (employee number 101).
下列示例显示使用一个SELECT语句和一个分级查询子句来返回Meier经理（雇员编号为 101）的所有直接下属。
Add a WHERE clause to limit the number of rows to test the movement of data.
添加where子句以限制转移的数据行数。
This can be done by using a timestamp or sequence number contained in the row, or by adding every column in the row to the WHERE clause of the UPDATE.
这可以通过使用数据行中包含的时间戳或序列号来进行，也可将数据行的每个列字段添加到UPDATE的where子句中。
For example, if used in a SELECT clause, it returns the partition number for each row of the table that was used to form the result of the SELECT statement.
例如，如果用在一个select子句中，那么该函数将返回表中组成select语句结果的每一行的分区号。
Let's add a WHERE clause to that SELECT statement by invoking the EDIT command and specifying statement number 2 in the sequence.
我们将调用EDIT命令，并在顺序中指定语句序号2，通过这些操作给上面的select语句添加where子句。
In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the resolution clause specifies the minimum number of rows to sample for column distributions.
在使用MEDIUM模式的显式的UPDATESTATISTICS操作中，可以在resolution子句中使用新的SAMPLINGSIZE选项为列分布抽样指定最小行数。
If the number of tuples, calculated by using the Cartesian product, exceeds the set threshold; the NON EMPTY clause is applied to the query.
如果通过使用Cartesian产品计算的元组数超过设定的阈值，将NONempty子句应用于查询。
For example, you can add a ROWNUM clause to limit the number of rows in Oracle or use the TOP clause for SQL Server.
例如，在Oracle中可以添加rownum子句以限制行数，对于SQLServer使用top子句。
Google holds a number of patents thanks to the On2 acquisition which it has granted use of its patents under a use but don't Sue clause.
由于收购了On 2,Google现在持有大量的专利，他说其他人可以使用这些专利而不会遭到起诉。
In explicit UPDATE STATISTICS operations in MEDIUM mode, a new SAMPLING SIZE option in the Resolution clause can specify the minimum number of rows to sample for column distributions.
在MEDIUM模式的显式的UPDATESTATISTICS操作中，resolution子句中新的SAMPLINGSIZE选项可以指定列分布进行抽样的最少行数。
When you see the asterisk, you know to look for that ID number in the Predicate Information section to see which predicate (condition in the WHERE clause) was related to that operation.
当你看到星号，通过查找在谓词信息中的ID号去看（在WHERE子句的条件中）哪个谓词关联到了那个操作。
So you pick a random number less than the number of results and use that as the offset in your LIMIT clause.
这样，你首先获取一个小于行数的随机数，然后根据这个便宜量使用limit得到结果。
The paper means to discuss and sum up the applications and translation of attributive clause based on a large number of examples in English practice.
本文就定语从句在英语实践中的应用以大量的例句作了总结性的论述。
The paper means to discuss and sum up the applications and translation of attributive clause based on a large number of examples in English practice.
本文就定语从句在英语实践中的应用以大量的例句作了总结性的论述。
应用推荐