表2描述了一些示例查询。
图1显示以上示例查询的输出。
示例查询测试正在进行元数据调用。
因此让我们看一个示例查询应用程序。
前面几节描述的示例查询以应用程序名称为基础。
The sample queries described in the previous sections are based on application names.
图6给出了所执行的预定义问题查询的示例查询结果。
Figure 6 shows a sample query result for a predefined problem query that was executed.
这个示例查询从已经定义好的CARS表中读取数据。
The sample query reads data from the table CARS that has already been defined. For the automobiles' data in the table CARS, the following assumptions apply.
这个文件包含了关于这个示例查询的访问计划和其他详细信息。
Access plan and other very detailed information can be found in this file for our example query.
示例查询选择型号为A 且正处在制造流程中、尚未完工的所有汽车
The sample query selects all cars of model A that are currently going through the manufacturing process
图2给出扩展的BaseDao接口,它支持按示例查询功能。
Figure 2 shows the BaseDao interface, which has been extended to support query-by-example functionality.
这些示例查询的结果都相当简单,因为fax元素是基于基本数据类型的。
The results of the sample queries are relatively simple because the fax element is based on a primitive data type.
返回的列表可以根据Notesformula语言查询、示例查询或视图进行过滤。
The lists returned can be filtered according to a Notes Formula language query, a query by example, or a view.
对于这个示例查询,最好使用文本而不是参数标记,并接受重复的准备阶段,如清单7所示。
For this example query, it would be better to use literals instead of parameter markers and to accept the repeated prepare phase, as shown in Listing 7.
我们使用前面的同一个示例查询来说明如何解释星型连接计划的SETEXPLAIN输出。
To show how to interpret SET EXPLAIN output for star join plans, we use the same example query as before.
清单7提供了一个示例查询,该查询用于列示新泽西州的所有客户姓名和电话号码。
Listing 7 provides an example query to list all the customer names and phone Numbers from state of New jersey.
DeveloperNet work上且带有诊断工具、示例查询以及一系列可用的表。
Developer Network and comes with diagnostics tools, example queries, and a list of available tables.
考虑如下示例查询,该查询用于发现所有同时在美国和欧洲销售的美容产品的总销售量。
Consider an example query that finds the aggregate sales of all the beauty products sold in the US that are also sold in Europe.
在本文的结尾,我们提供了一些固定的示例查询,将有助于用户从这些表中筛选出所需信息。
At the end of the paper, we provide some sample canned queries that will help users to filter the information needed out of these tables.
下面的示例查询针对名为 add_queue 的字段查询队列 AMDC79_ps 的连接配置。
The following example queries the attachment configuration for queue AMDC79_ps for a field named add_queue.
在这个示例查询中,XMLExists指示DB 2判断一个给定的XML文档是否包含一个包括指定城市的CARPOOL地址。
In this sample query, XMLExists instructs DB2 to determine if a given XML document contains a CARPOOL address that includes the specified city.
这个示例查询使用XMLEXISTS来选择“WW”部门V15,并应用XMLQUERY来返回该department文档中的所有员工姓名。
This sample query USES XMLEXISTS to select the "WW" department V15 and applies XMLQUERY to return all employee names from that department document. The result is.
在本示例中,查询返回了文档中已编写了多于三本书的所有作者的名字。
In this example, the query returns the names of all authors in the document who have written more than three books.
使用通配符搜索的一个查询示例见清单21。
A sample query using wildcard search is shown in Listing 21.
现在,让我们来定义一些示例数据和表,以查看具体的查询示例。
Now, let's define some sample data and tables so that we can look at concrete query examples.
对于示例数据,该查询不返回任何记录。
Given the sample data, no records are returned for this query.
可以在示例一节中找到一些查询示例。
后面的查询示例搜索这些XML文档的特定元素。
Subsequent query examples search in specific elements of these XML documents.
虽然前面的例子中没有显示,但您可能定义了“筛选参数”(类似于示例SQL查询谓词)来限制为此图返回的行。
Although not shown in the previous example, you could have defined "filter arguments" (similar to simple SQL query predicates) to restrict the rows returned for this graph.
表1中的信息就基于这样的查询的示例输出。
The information in Table 1 is based on sample output from such a query.
下一节中的查询示例将以表1中展示的样例数据为基础。
The query examples in the next section are based off of the sample data shown in Table 1.
应用推荐