Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
The information in both rows provides enough detail to generate a well formed SQL select statement, which will be executed against the nodes specified data source.
两个行中包含的信息为生成完整的SQL选择语句提供了足够的细节,该语句将对指定数据源的节点执行。
The above query elements property table would produce the following SQL select query.
上面的查询元素属性表应该生成以下SQL选择查询。
The second SQL select creates rows for the "Has_name" predicate, which connects person instances to their name strings.
第二个SQL选择语句为“Has_name”谓词创建行,它将人实例与他们的名字字符串联系起来。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句,它从数据库中获取几行。
The key is using the XMLQUERY reserved word to indicate an XQuery that is executed against an XML document that is passed in via the SQL select statement.
关键在于使用XMLQUERY保留字表明要通过SQL选择语句执行针对传入XML文档的XQuery。
Selecting HPL query brings up a small SQL select statement panel that shows a select query for the table in use.
选择HPLquery将弹出一个小的SQL选择语句面板,此面板显示正在使用的表的选择查询。
Identify the rows and columns to select from Informix and execute an SQL select to retrieve the data.
确定从Informix选择的行和列,并执行一条SQL select语句,以检索数据。
You can use standard SQL SELECT statements on both message data and database tables.
您可以在消息数据和数据库表上使用标准的SQL SELECT语句。
Imagine running a SQL SELECT statement and merging the results directly into an HTML table marked up to your specifications.
想象一下,运行一个SQL select语句,并将结果直接合并到一个符合自己的规范的HTML表格中。
Do you remember how to restrict SQL SELECT statements to return only rows for customers living in zip code 95116?
还记得怎样限制SQL select语句,使之仅返回居住在邮政编码为95116的地区的客户的行吗?
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样,表函数也可以在SQL select语句中使用。
Using a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT statements.
本教程通过一系列简单的例子,阐释如何用标准SQL SELECT 语句检索IBMDB2数据库中的数据。
The first rule is to always provide only the exact columns that you need to retrieve in the SELECT-list of each SQL SELECT statement.
第一条规则是始终在每条 SQL SELECT语句的SELECT 列表中只提供 确实需要检索的那些列 。
Building an SQL JOIN command starts as a regular SQL SELECT command, but instead of specifying fields from just one table, you can specify fields from more than one table.
构建SQLJOIN命令时,开始仍是常规的SQL SELECT命令,但这里不是仅指定来自一个表的字段,而是指定来自多个表的字段。
The second method is to use something similar to an SQL SELECT statement.
第二种方法是使用某种类似于SQL SELECT 语句的东西。
We will see a little later how to work with SQL SELECT query and the result set using the FESI database access extension.
我们不久后将看到如何使用SQL SELECT查询及运用FESI数据库访问扩展名的结果集。
Besides specifying the format of the data that is to be written to the output file, you must also provide the name of that file, and an SQL SELECT statement to specify the data that is to be exported.
除了要指定写到输出文件中的数据格式之外,还必须提供该文件的名称和一个用于指定输出数据的SQL SELECT语句。
Be familiar with the basics of the SQL SELECT statement, which was discussed in the fifth article in this series.
熟悉SQL select语句的基础知识,本系列的第五篇文章有介绍。
Together information contained in both rows provides enough detail to generate a well formed SQL select statement, which will be executed against the nodes specified data source.
加在一起,两个行中包含的信息为生成完整的SQL select语句提供了足够的细节,该语句将对指定数据源的节点执行。
An Open SQL select clause always needs a data structure where it can put the results of the call, such as a structure or an internal table for bulk calls.
OpenSQL select子句总是需要一个数据结构,比如结构或内部表(对于大量调用),它要把调用的结果放在这个数据结构中。
The queries are standard SQL select statements that operate against the PWH tables.
这些查询是标准的SQL select语句,它们基于pwh表执行。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQL select语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
Next, create a simple SQL select statement that returns an employee record.
接下来,创建一个简单的SQL select语句,该语句返回一个雇员记录。
So the N extra SQL select statements on pojoB were cut down to N/10.
因此N次额外的关于pojoB的select SQL语句被减少到了N/10次。
It provides the functions for executing the SQL select/insert/update/upsert/delete statements via the Teradata DBC/SQL partition.
它提供了通过TeradataDBC/SQL分区执行 SQL select/insert/update/upsert/delete语句的功能。
Just create the indexes and add the where clause to your SQL select statements, and you are good to go.
只需创建索引并在SQL select语句中添加where子句,就会使用索引。
As a result, the DB2 update lock for the row is released and this row is found by the next SQL select statement in Listing 2.
因此,会释放这一行的DB2更新锁,清单2中的下一个SQL select语句会看到这一行。
Each data source is then read by a simple SQL SELECT statement, and the join is completed within the InfoSphere DataStage process.
只通过简单的SQL select语句对每个数据源进行读取,并且在InfoSphereDataStage流程之内完成连接。
You define your database format with three tables, and proceed to query them, showing that you can both emulate traditional SQL SELECT, and also provide an associative lookup.
定义一个具有3个表的数据库,然后对它们进行查询,既可以模仿传统的SQL SELECT,也可以进行关联查找。
应用推荐