The SQL SELECT command you produced is
这样您产生的SQL SELECT命令是
Fetching data from the database using the SQL SELECT query.
使用SQL SELECT查询从数据库取回数据。
For this, you need to extend your SQL SELECT command using a JOIN.
为此,您需要使用一个JOIN来扩展SQL SELECT命令。
So the N extra SQL select statements on pojoB were cut down to N/10.
因此N次额外的关于pojoB的select SQL语句被减少到了N/10次。
The second method is to use something similar to an SQL SELECT statement.
第二种方法是使用某种类似于SQL SELECT 语句的东西。
Next, create a simple SQL select statement that returns an employee record.
接下来,创建一个简单的SQL select语句,该语句返回一个雇员记录。
Note: This is the equivalent to adding a where clause in a SQL SELECT statement.
注意:这相当于在SQL select语句中增加一个where子句。
The above query elements property table would produce the following SQL select query.
上面的查询元素属性表应该生成以下SQL选择查询。
The queries are standard SQL select statements that operate against the PWH tables.
这些查询是标准的SQL select语句,它们基于pwh表执行。
You can use standard SQL SELECT statements on both message data and database tables.
您可以在消息数据和数据库表上使用标准的SQL SELECT语句。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句,它从数据库中获取几行。
Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause.
可以把这个函数看作相当于带WHERE 子句的SQL SELECT语句。
SELECT: Returns a set of variable bindings that satisfy the query (similar to SQL SELECT).
SELECT:返回满足查询的一组变量绑定(类似SQL SELECT)。
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样,表函数也可以在SQL select语句中使用。
Identify the rows and columns to select from Informix and execute an SQL select to retrieve the data.
确定从Informix选择的行和列,并执行一条SQL select语句,以检索数据。
For example, an SQL SELECT statement could use a parameter to define the criteria of a WHERE clause.
举例来说,SQL SELECT语句可以使用一个参数来定义一个WHERE条款规则。
Just create the indexes and add the where clause to your SQL select statements, and you are good to go.
只需创建索引并在SQL select语句中添加where子句,就会使用索引。
Selecting HPL query brings up a small SQL select statement panel that shows a select query for the table in use.
选择HPLquery将弹出一个小的SQL选择语句面板,此面板显示正在使用的表的选择查询。
Do you remember how to restrict SQL SELECT statements to return only rows for customers living in zip code 95116?
还记得怎样限制SQL select语句,使之仅返回居住在邮政编码为95116的地区的客户的行吗?
Be familiar with the basics of the SQL SELECT statement, which was discussed in the fifth article in this series.
熟悉SQL select语句的基础知识,本系列的第五篇文章有介绍。
The second SQL select creates rows for the "Has_name" predicate, which connects person instances to their name strings.
第二个SQL选择语句为“Has_name”谓词创建行,它将人实例与他们的名字字符串联系起来。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQL select语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
The row specifying the column is used to populate the select, FROM and ORDER BY clauses of the SQL select statement.
指定列的行用来组成SQL select语句的select、FROM和ORDERBY子句。
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数据库访问扩展名的结果集。
Imagine running a SQL SELECT statement and merging the results directly into an HTML table marked up to your specifications.
想象一下,运行一个SQL select语句,并将结果直接合并到一个符合自己的规范的HTML表格中。
Update 2 is an SQL SELECT statement with the same XMLQUERY function, transform expression, and WHERE clause, as in Update 1.
更新2是一个SQL select语句,其中包含与更新1相同的XMLQUERY函数、转换表达式和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语句会看到这一行。
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语句的功能。
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流程之内完成连接。
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 列表中只提供 确实需要检索的那些列 。
应用推荐