subselect 中文意思是什麼
subselect
解釋
細部選定-
To ensure that only 10 rows are deleted, the column specified in the subselect statement
為了確保僅刪除10行,嵌套select語句( -
Further, it could subselect only methods with the value property exceeding, say, 25
而且,它可以進一步只選擇(比如說) value屬性超過25的方法。 -
If the insert statement is used with a subselect, the returned data can be stored into db2 tables
如果將insert語句與子查詢一起使用,那麼返回的數據便可以存儲到db2表中。 -
Added information about specifying a primary key when you use a subselect statement with an order by clause
添加了有關在將嵌套select語句與order by子句一起使用時指定主鍵的詳細信息。 -
Is a variable, literal value, expression, or a subselect statement enclosed with parentheses that returns a single value
返回單個值的變量、文字值、表達式或嵌套select語句(加括號) 。 -
If you have to use top to delete rows in a meaningful chronological order, you must use top together with order by in a subselect statement
如果需要使用top來刪除按有意義的時間順序排列的行,您必須同時使用top和order by子句。 -
Using a nonkey column in the subselect statement may result in the deletion of more than 10 rows if the specified column contains duplicate values
如果指定列包含重復的值,則在嵌套select語句中使用非鍵列可能會導致刪除的行超過10個。 -
Enable grouping by a column that is derived from a scalar subselect, or a function that is either not deterministic or has external access
啟用按從標量嵌套select語句派生的列進行分組,或者按不確定性函數或有外部訪問的函數進行分組。 -
If the measure had a third aggregation, then the select statement generated here would itself be used as a subselect on which the third aggregation function would be applied
)如果這個度量還有第三個聚合,那麼這個選擇語句本身作為子查詢,第三個聚合函數應用於它。
分享友人