All of the SQL expressions for any attributes that were selected as columns in the select clause should also be in the GROUP BY clause.
对于作为select子句中的列的任何属性,它们的SQL表达式也应该放在GROUP by子句中。
An Open SQL select clause always needs a data structure where it can put the results of the call, such as a structure or an internal table for bulk calls.
Open SQL select子句总是需要一个数据结构,比如结构或内部表(对于大量调用),它要把调用的结果放在这个数据结构中。
If you use XML predicates in the XMLQUERY function in the select clause of an SQL statement, these predicates do not eliminate any rows from the result set and therefore cannot use an index.
如果在sql语句的select子句的XMLQUERY函数中使用xml谓词,则这些谓词不会从结果集中排除任何行,因此不能使用索引。
应用推荐