A single select statement is generated and the join is pushed to the database.
单个选择语句生成，联接被推到数据库。
This function takes a string value as input which is a valid SQL full select statement.
此函数将一个字符串值作为输入，该字符串是一个有效的SQL全选择语句。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句，它从数据库中获取几行。
The second performs a select statement, using the alternative question mark placeholders.
而第二个例子使用问号占位符执行一条select语句。
Note: The select statement specified in this example has a parameter marker called: empno.
注意：这个例子中指定的select语句有一个名为：empno的参数占位符。
Using a select statement to select from a data source into an external table (see Listing 3).
使用select语句从一个数据源选择构成外部表的数据(参见清单3)。
In the example, this is represented by the outermost select statement, which USES S1 as a subquery.
在这个示例中，这由最外层的选择语句表示，这个语句将S1用作子查询。
Selecting HPL query brings up a small SQL select statement panel that shows a select query for the table in use.
选择HPLquery将弹出一个小的SQL选择语句面板，此面板显示正在使用的表的选择查询。
The row specifying the column is used to populate the select, FROM and ORDER BY clauses of the SQL select statement.
指定列的行用来组成SQLselect语句的select、FROM和ORDERBY子句。
The next example is executing a select statement and working with the set of results returned by the database server.
下一个例子是执行一条select语句，并处理由数据库服务器返回的结果集。
This second select statement is joined with the Common Table Expression (CTE) itself by linking parent to child data.
第二个SELECT语句通过将父数据链接至子数据与公共表表达式 (CTE) 联接。
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中的下一个SQLselect语句会看到这一行。
When you run Listing 2, you should see the same results as in Listing 3. Listing 3 shows the result from the select statement.
运行清单2时，您应该能看到与清单3相同的结果。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义，所以不会影响查询性能。
This article introduced the select statement and demonstrated how to use it properly with Apache Derby to select and extract data from a database.
本文介绍了select语句，并展示了如何恰当地将它与ApacheDerby结合使用来选择和提取数据库中的数据。
In the first select statement that was generated, change the name of the table to an invalid value. (This example changes PROJECT table to PROJECT1.)
在生成的第一个选择语句中，把表名改为无效的值(这个示例把PROJECT表改为PROJECT1)。
A separate select statement will be needed to properly calculate each set of measures that share the same number and dimensional order of aggregations.
对于每一组具有相同数量和维次序的聚合的度量，需要用单独的选择语句来正确地计算。
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。
For example, some databases provide special syntax on the select statements to declare the intentions of updating the rows selected by the select statement.
例如，有些数据库在select语句上提供了特殊的语法，声明用来更新select语句所选中的行。
The result of the current iterative select statement is merged with the result of the initial select statement and all results returned by the previous iterations using a UNION ALL clause.
使用UNIONALL子句，可将当前的迭代SELECT语句的结果与初始 SELECT 语句的结果以及之前的迭代返回的所有结果合并在一起。
FROM the syntax in Listing 2, you can see that a basic select statement requires only a select and a FROM; you must specify what data to select and indicate the location of the data of interest.
从清单2的语法中，可以看到基本的select语句只需要SELECT和FROM语句；必须指定要选择的数据并指明您感兴趣的数据的位置。
So to find the row that satisfies the predicate in the select statement, the optimizer has to lock, read in, and compare all the rows in the main table with the value supplied in the predicate.
因此要找到满足select语句中谓词的行，这个优化器必须将主表中的所有行上锁、读取它们的值并与谓词中提供的值进行比较。
Step 3: Results from attempting a SELECT statement.
Step3：尝试执行一个select语句的结果。
Listing 11 shows the access plan for the SELECT statement.
清单11展示了select语句的访问计划。
The CDR remaster command accepts only one SELECT statement.
cdrremaster命令只接受一个SELECT语句。
The SELECT statement of a replicate definition can be redefined.
复制定义的select语句可以重新定义。
The output of the above SELECT statement is shown in Listing 13.
清单13显示了以上的select语句的输出。
Note that the SELECT statement above is captured by the snapshot.
请注意，上面的SELECT语句是由快照所捕获的。
Listing 5 shows the output from the SELECT statement in Listing 4.
清单5显示了来自清单4中的select语句的输出。
应用推荐