You can use ASC for ascending (A-Z, 0-9) or DESC for descending (Z-A, 9-0). Ascending sorts are the default. Each column can have its own direction specified, as in the following example:SQL Copy SELECT ProductCategoryID AS Category, ProductName FROM Production.Product ORDER BY ...
DATA:GV_CARRID TYPE SFLIGHT-CARRID,GV_PRICE TYPE I.SELECT CARRID SUM( PRICE ) INTO (GV_CARRID,GV_PRICE) FROM SFLIGHT GROUP BY CARRID HAVING SUM( PRICE ) > 1000 ORDER BY CARRID DESCENDING.WRITE:/ GV_CARRID,GV_PRICE.ENDSELECT. 效果示例图...
That is, you indicate that the result rows should be arranged by descending values of the price column. The resulting SQL might look like this: 复制 SELECT * FROM titles ORDER BY price DESC You can sort by multiple columns For example, you can create a result set with one row for ...
命名空间: Microsoft.Data.SqlClient 程序集: Microsoft.Data.SqlClient.dll 包: Microsoft.Data.SqlClient v5.0.0 指定数据行排序方式。csharp 复制 public enum SortOrder继承 Enum SortOrder 字段展开表 Ascending 0 按升序排序各行。 Descending 1 按降序排序各行。 Unspecified -1 默认值。 不指定排序...
SortDirection direction2 = SortDirection.Ascending; if (DirectionList2.SelectedValue == "DESC") direction2 = SortDirection.Descending; // Use the Sort method to programmatically sort the ListView // control using the sort expression and direction. ContactsListView.Sort(expression, direction2); } /...
SELECT<lines>*...ORDERBY<f1>[ASCENDING|DESCENDING]<f2>[ASCENDING|DESCENDING]... 案例代码演示(CARRID升序) 代码语言:javascript 复制 DATA:GV_CARRIDTYPESFLIGHT-CARRID,GV_PRICETYPEI.SELECTCARRIDSUM(PRICE)INTO(GV_CARRID,GV_PRICE)FROMSFLIGHTGROUPBYCARRIDHAVINGSUM(PRICE)>1000ORDERBYCARRIDASCENDING.WRIT...
为了按照自定义顺序排序或者对不可比较对象排序,可以使用函数 sortedBy() 和 sortedByDescending()。 它们接受一个将集合元素映射为 Comparable 值的选择器函数,并以该值的自然顺序对集合排序。 val numbers = listOf("one", "two", "three", "four") ...
Click the table header to sort data by a single column or multiple columns in ascending or descending order. Sort data by a single column or multiple columns in the set order during the template preview. Customize a sort. If Result Set Filter and Sort After Expansion are applied at the sam...
DESC: The sort order for this expression is descending. If sort direction is not explicitly specified, then by default rows are sorted ascending. nulls_sort_order Optionally specifies whether NULL values are returned before/after non-NULL values. Ifnull_sort_orderis not specified, then NULLs sort...
ReportingServices.RdlObjectModel 程序集: Microsoft.ReportingServices.Designer.Controls.dll 指定排序的方向。 C# 复制 public enum SortDirections 继承 Enum SortDirections 字段 展开表 Ascending 0 方向为升序。 Descending 1 方向为降序。 适用于 产品版本 SQL Server .NET SDK 2016 ...