This query will return only 200 rows.
该查询将只返回200行。
This query plan shows full table scans.
该查询计划显示了全表扫描。
This query simply gets all of the Teams.
该查询获取所有Teams。
Two aspects of this query are worth noting.
该查询有两个方面值得注意。
Listing 3 illustrates this query in practice.
清单3实际演示了此查询。
A few aspects of this query are worth noting.
该查询的有些方面值得注意。
Select a record from the results of this query.
从这个查询的结果中选择一个记录。
Figure 13 illustrates the output of this query.
图13显示了此查询的输出。
Figure 3 illustrates the workings of this query.
图3演示了该查询是如何工作的。
Listing 3 shows this query and how it can be used.
清单3显示该查询以及使用方法。
DB2 returns a three-row result set for this query.
对于这个查询，DB2返回一个由三行组成的结果集。
This query plan shows the use of a functional index.
该查询计划展示了函数索引的使用。
It is noteworthy to look at the output of this query.
这里有必要看一下这个查询的输出。
Since this query is a cursor, DB2 is facing a dilemma.
因为这个查询是一个游标，因此DB 2正面临一个窘境。
This query returns 12 records from the EMPLOYEE table.
该查询从employee表返回12条记录。
This query returns six records from the EMPLOYEE table.
该查询从employee表返回6条记录。
You may wonder why a WHERE clause appears in this query.
您可能想知道，为什么这个查询中出现了一个WHERE 子句。
This query will return a set of XML elements and values.
这个查询将返回一组xml元素和值。
Listing 11 shows the XML output from running this query.
清单11展示了运行该查询产生的XML输出。
This query executes successfully but returns no records.
这条查询可以执行成功，但是不返回任何记录。
This query returns five records from the EMPLOYEE table.
该查询从employee表返回5条记录。
This query USES square brackets, so what's wrong with it?
这个查询使用了方括号，那么它错在哪里呢？
This query returns four records from the EMPLOYEE table.
该检索从employee表返回4条记录。
This query plan shows an index scan using our functional index.
该查询计划显示索引扫描使用了函数索引。
Figure 12 illustrates what the output of this query looks like.
图12显示了此查询的输出。
The threshold attribute of the element is ignored by this query.
此查询将忽略元素的阈值属性。
The result from this query is an XML representation of your data.
这个查询生成的结果是数据的XML表示。
Other users that would have qualified for this query will be ignored.
符合该查询条件的其他用户将被忽略。
Running this query should return the XML document shown in Listing 4.
运行该查询将返回清单4所示的XML文档。
Secondly, returning many empty rows makes this query needlessly slow.
其次，返回很多空行使查询速度不必要地慢了下来。
应用推荐