select list 中文意思是什麼
select list
解釋
選題目錄, 選書一覽-
List, select and clear items as appropriate
列表中選擇和清除項。 -
Use adventureworks ; go select productmodelid, avg listprice as average list price from production. product where listprice 1000 group by productmodelid order by productmodelid ; go
以下示例在只檢索標價大於$ 1000的行后，將結果進行分組。 -
To run the query successfully, convert any long fields in the select list to the
若要使查詢成功執行，請使用cast或convert將選擇列表中任何比較長的欄位轉換為 -
You can apply this function to one of the columns in the select list
該函數可以應用於選擇列表中的一列。 -
Specifies the name of a new table to be created, based on the columns in the select list and the rows chosen by the where clause
根據選擇列表中的列和where子句選擇的行，指定要創建的新表名。 -
There is no relationship between the columns in the group by clause and the nonaggregated columns in the select list
Group by子句中的列和select列表中的非聚集列之間不存在關系。 -
The group by clause must contain all nonaggregated columns in the select list, and can contain other columns not in the select list
Group by子句必須包含選擇列表中的所有非聚集列，而且可以包含選擇列表中沒有的其他列。 -
The group by clause must contain all nonaggregated columns in the select list, and must not contain other columns not in the select list
Group by子句必須包含選擇列表中的所有非聚集列，而且不能包含選擇列表中沒有的其他列。 -
To combine all of the separately calculated measures together into one result, each of these separate select statements are joined together with a full outer join on the attribute columns of the select list
要將所有單獨計算的度量組合在一個結果中，應該用選擇列表的屬性列上的完全外聯結將這些單獨的選擇語句聯結在一起。 -
The order by clause can include items that do not appear in the select list
Order by子句可包含未顯示在選擇列表中的項。 -
Specifies whether columns in an order by clause must be in the select list
指定order by子句中的列是否必須在選擇列表中。 -
Suser sname can be used in a select list, in a where clause, and anywhere an expression is allowed
Suser _ sname可以在選擇列表、 where子句和任何允許使用表達式的地方使用。 -
For example, in a three - table join, only one table can be used to bridge from one of the other tables to the third table, and none of the columns from the middle table have to be referenced in the select list
選擇列表不必包含聯接中每個表的列。例如，在三表聯接中，只能用一個表作為中間表來聯接另外兩個表，而選擇列表不必引用該中間表的任何列。 -
A sort column can be specified as a name or column alias, or a nonnegative integer representing the position of the name or alias in the select list. an integer cannot be specified when the
可以將排序列指定為一個名稱或列別名，也可以指定一個表示該名稱或別名在選擇列表中所處位置的非負整數。 -
Columns that are included in the select list is set to the smallest value of the following : the actual size of the
列返回的數據長度被設置為下列值中的最小值： -
All computed columns appear within the select list
所有的計算列都出現在選擇列表中。 -
In a select statement with a compute clause, the order of columns in the select list overrides the order of the aggregate functions in the compute clause
在帶有compute子句的select語句中，選擇列表中的列順序優于compute子句中的聚合函數順序。 -
An order by clause, unless there is also a top clause in the select list of the select statement
Order by子句，除非在select語句的選擇列表中也有一個top子句。 -
Additionally, when the select statement includes a union operator, the column names or column aliases must be those specified in the first select list
此外，當select語句包含union運算符時，列名或列的別名必須是在第一選擇列表內指定的列名或列的別名。 -
However, if select distinct is specified, or if the statement contains a group by clause, or if the select statement contains a union operator, the sort columns must appear in the select list
但是，如果未指定select distinct ，或者如果select語句包含union運算符，則排序列必須出現在選擇列表中。
分享友人