选择语句。
Figure 31: Create new select statement.
图31：创建新的select语句。
You can confirm that with the select statement in Listing 3.
可利用清单3其中的select语句进行确认。
The select statement for this method would normally look as follows.
这个方法的select语句通常如下所示。
Next, create a simple SQL select statement that returns an employee record.
接下来，创建一个简单的SQLselect语句，该语句返回一个雇员记录。
This function takes a string value as input which is a valid SQL full select statement.
此函数将一个字符串值作为输入，该字符串是一个有效的SQL全选择语句。
The final select statement shows the stock_num column with the original set of data.
最后一个select语句展示了包含原始数据集的 stock_num列。
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) 联接。
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.
对于每一组具有相同数量和维次序的聚合的度量，需要用单独的选择语句来正确地计算。
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 语句的结果以及之前的迭代返回的所有结果合并在一起。
Data values from example SELECT statement.
来自select语句示例中的数据值。
The rest of the SELECT statement is optional.
select语句的其他部分都是可选的。
Step 3: Results from attempting a SELECT statement.
Step3：尝试执行一个select语句的结果。
For example, consider the following SELECT statement.
例如，考虑下列SELECT语句。
Listing 11 shows the access plan for the SELECT statement.
清单11展示了select语句的访问计划。
The CDR remaster command accepts only one SELECT statement.
cdrremaster命令只接受一个SELECT语句。
应用推荐