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命令。
Note: This is the equivalent to adding a where clause in a SQL SELECT statement.
注意:这相当于在SQL select语句中增加一个where子句。
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语句。
The above query elements property table would produce the following SQL select query.
上面的查询元素属性表应该生成以下SQL选择查询。
Think of this function as the equivalent to an SQL SELECT statement with a WHERE clause.
可以把这个函数看作相当于带WHERE 子句的SQL SELECT语句。
An SQL select statement that will be executed to retrieve several rows from the database.
一个SQL选择语句,它从数据库中获取几行。
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语句,以检索数据。
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 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子句。
The first line of the query issues a SQL SELECT statement that invokes an industry-standard SQL function (XMLQUERY).
查询的第一行发出一个SQL select语句,其中调用了一个行业标准的SQL函数(XMLQUERY)。
The second SQL select creates rows for the "Has_name" predicate, which connects person instances to their name strings.
第二个SQL选择语句为“Has_name”谓词创建行,它将人实例与他们的名字字符串联系起来。
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 列表中只提供 确实需要检索的那些列 。
I built master-detail relations with the result of SQL SELECT commands, showing when it can be more convenient to use SQL JOINs instead.
我用SQL SELECT命令建立了master - detail关系,展示了何时使用SQLJOIN更方便。
Because both of these views are defined with a single SQL select statement on the underlying table, the query performance will not suffer.
因为这两个视图都是在下面的表格上使用单独的SQL选择语句进行定义,所以不会影响查询性能。
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数据库中的数据。
Since we are now using SQL SELECT statements, the restore_where argument changes from a Perl pattern match to the syntax of an SQL where clause.
因为现在使用的是SQL select语句,所以restore_where自变量从Perl模式匹配改成SQL where子句。
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。
Normally when you select records from a data source using a SQL SELECT statement, you get a result set, which is a set of records from a table or a query.
语句从数据源选择记录时,通常会得到一个结果集,即一组来自表或查询的记录。
应用推荐