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语句的输出。
Ordernames (string) is the SQL order by clause of a Select statement.
Ordernames(字符串)是Select语句的SQLorderby子句。
A single select statement is generated and the join is pushed to the database.
单个选择语句生成,联接被推到数据库。
Specify a SELECT statement to define which documents are displayed the view.
指定一个SELECT语句来定义哪个文档将被显示在这个视图中。
These predicates can also be used in the WHERE clause of the SELECT statement.
这些谓词还可以用于select语句的where子句中。
Note: This is the equivalent to adding a where clause in a SQL SELECT statement.
注意:这相当于在SQLselect语句中增加一个where子句。
A SELECT statement can have multiple columns listed following the SELECT keyword.
在SELECT关键字之后,select语句可以列出多个列。
The select statement would look like: select catalog_num, cat_descr FROM catalog.
select语句类似如下:select catalog_num, cat _ descrFROMcatalog。
In such a scenario, the connector executes a SELECT statement with a WHERE clause.
在这种场景中,连接器执行带有where子句的SELECT语句。
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选择语句,它从数据库中获取几行。
When you open the view, the status bar shows the entire Select statement that you created.
当您打开视图时,状态栏将显示创建的整条选择语句。
Again, you can verify that by issuing a SELECT statement in the DB2 Command Line window.
同样,可以通过在DB 2命令行窗口中发出select语句来对此进行验证。
The second performs a select statement, using the alternative question mark placeholders.
而第二个例子使用问号占位符执行一条select语句。
The SELECT statement allows us to return one row per region identified by the name column.
这个select语句对于每个地区返回一行,地区名由name列表示。
Note: The select statement specified in this example has a parameter marker called: empno.
注意:这个例子中指定的select语句有一个名为:empno的参数占位符。
Just like any other built-in function, table functions can be used in a SQL SELECT statement.
就像其他的内建函数一样,表函数也可以在SQLselect语句中使用。
In that case, the SELECT statement verified that the tables were created and loaded properly.
在该示例中,select语句验证了表是否已正确创建和加载。
Typically, you create a SELECT statement, perhaps JOINing many tables together to yield a row.
通常,将创建select子句,可能需要把许多表join在一起才能得到行。
In the example, this is represented by the outermost select statement, which USES S1 as a subquery.
在这个示例中,这由最外层的选择语句表示,这个语句将S1用作子查询。
In the SQL programming language, the task of performing a query falls to the SELECT statement.
在SQL编程语言中,执行查询的任务属于SELECT语句。
Note: To detect a cycle, only the results returned by the iterative SELECT statement are checked.
注意:要检测循环,在检测循环时,系统只会检查迭代select语句返回的结果。
In this case, they can issue a SELECT statement to identify rows that qualify then DELETE those rows.
在这种情况下,他们可以发出一条select语句来识别符合条件的行,然后再DELETE那些行。
To verify that the update is successful, launched the DB2 command line window and issue a SELECT statement.
为了验证更新成功,需要启动DB2命令行窗口,并发出SELECT语句。
应用推荐