指定查询谓词(where子句)。
在该子句中可以指定多个文件。
或者语句子句是否会覆盖连接属性?
Will the RS be stronger, or can the statement clause overwrite the connection property?
用return子句完成查询。
需要在from子句中指定联结谓词。
在copy子句中选择节点。
这使select子句成为代码循环。
在下面的样本中,where子句使用?
注意where子句中使用了参数标记。
有时,从查询中忽略from子句很有意义。
Sometimes, it makes sense to omit the from clause from a query.
在WHERE子句的函数中避免封装过滤列。
Avoid wrapping filtering columns within a function in the WHERE clause.
字符串变量需要按正确的语法包含sql子句。
A string variable needs to contain the SQL clause in the correct syntax.
支持ORDERBY子句中使用常量已经过时。
Support for constants in ORDER BY clause have been depreciated.
在modify子句中可以使用多个更新表达式。
Multiple updating expressions can be used in the MODIFY clause.
令人感兴趣的是,where子句在递归说明之前。
It is interesting to note how the WHERE clause preceded the recursive specification.
下面的例子演示了在触发器中使用WHEN 子句。
The following example demonstrates the use of the WHEN clause in the trigger.
如更新9所示,modify子句包含多个更新操作。
As you see in update 9, the MODIFY clause contains multiple update operations.
只需将合适的where子句添加到SQL查询中即可。
You simply add the appropriate WHERE clause to the SQL query.
使用WITHreturn子句声明游标。
与RCTE语法相比,分级查询子句较更容易理解。
The hierarchical query clause is easier to understand than the RCTE syntax.
return:return子句返回修改后的值。
USING子句提供一种便利,用于声明名称空间的前缀。
The USING clause is a convenience, used to declare prefixes for namespaces.
如果没有包括任何where子句,则删除表中的所有行。
If no WHERE clause is included, all rows in the table are deleted.
WHERE 子句基于资产名称联接临时和永久XML数据。
The WHERE clause joins the transient and persistent XML data based on asset names.
SQLwhere子句表明,我们只想要与信用违约交易相关的结果。
The SQL WHERE clause indicates that we want only results related to credit default trades.
这些属性出现在SELECT子句和GROUPBY 子句中。
The attributes appear in both the SELECT clause and the GROUP BY clause.
对于每个将要返回的结果集,使用WITHreturn子句声明游标。
Declare cursors for each of the result sets to be returned that specify the WITH return clause.
从HQL的WHERE子句中通常可以猜到相应的SQL WHERE子句。
From the WHERE clause in HQL you can usually guess the corresponding SQL WHERE clause.
目前,先要记住必须保证for子句定义的变量同时出现在return子句中。
For now, though, always ensure you have the variable defined in your for clause reappearing in your return clause.
目前,先要记住必须保证for子句定义的变量同时出现在return子句中。
For now, though, always ensure you have the variable defined in your for clause reappearing in your return clause.
应用推荐