You will rarely need this query.
您很少需要此查询。
What is the result type of this query?
这一查询结果是什么类型？
Two aspects of this query are worth noting.
该查询有两个方面值得注意。
Performance of this query will not be good.
该查询的性能并不好。
Listing 3 illustrates this query in practice.
清单3实际演示了此查询。
A few aspects of this query are worth noting.
该查询的有些方面值得注意。
Figure 2 shows a possible plan for this query.
图2显示了这个查询的一个可能的计划。
If you run this query, the result should show.
如果运行该查询，结果如下所示。
Select a record from the results of this query.
从这个查询的结果中选择一个记录。
Figure 13 illustrates the output of this query.
图13显示了此查询的输出。
The result of this query is shown in Listing 8.
此查询的结果显示在清单8中。
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返回一个由三行组成的结果集。
Two aspects of this query deserve some explanation.
这个查询有两个方面要解释一下。
Running this query will produce a result similar to
运行该查询将产生类似以下的结果
It is noteworthy to look at the output of this query.
这里有必要看一下这个查询的输出。
The next section will show how this query can be fixed.
下一小节将展示如何修复该查询。
You may wonder why a WHERE clause appears in this query.
您可能想知道，为什么这个查询中出现了一个WHERE 子句。
Listing 11 shows the XML output from running this query.
清单11展示了运行该查询产生的XML输出。
Note that this query pulls out the person's name and city.
请注意，查询检索人的姓名和所在城市。
You can see the expected result of this query in Figure 10.
在图10中您可以看到该查询的预期结果。
But, this query is not what you want, for multiple reasons.
但是，这个查询并不是您想要的，原因有好几个。
Given the sample data, no records are returned for this query.
对于示例数据，该查询不返回任何记录。
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文档。
Executing this query should return a result like the one in Figure 8.
执行该查询将返回与图8一样的结果。
应用推荐