orderby

  • 网络排序;排序方式;排序升

orderbyorderby

orderby

排序

Linq语法及用法 二_追求,永不言弃_百度空间 ... QuerySyntax 查询语法 orderby 排序 group by into 分组 ...

排序方式

jeecms学习 - 熊仔其人的日志 - 网易博客 ... sysContent 列表显示方式 orderBy 排序方式 recommend 是否推荐 ...

排序升

Linq - WXWinter(冬) - 博客园 ... 6.2.3 Where 条件 16 6.2.4 OrderBy 排序升 17 6.2.5 OrderByDescending 排序降 17 ...

正序排序

08 - 沧海一笑 - 网易博客 ... Where - 筛选 OrderBy - 正序排序 OrderByDescending - 倒序排序 ...

文章排序

mambo曼波整站系统 v5.3.0下载... ... “分类条目数 cat_items” 改名为 “文章排序 orderby” 3) 删除参数“分类名称 category” ...

对查询结果进行排序

《SQL语法与范例详解词典》-... ... DISTINCT 去除查询结果中的重复记录23 ORDERBY 对查询结果进行排序24 WHERE 定义 …

排序子句

ASP.NET 4权威指南 目录 - 51CTO.COM ... 9.2.3 where 条件子句 332 9.2.4 orderby 排序子句 332 9.2.5 group 分组子句 333 ...

排序值

模板函数getcategories ... [description] 描述 [orderby] 排序值 [data] (3.9.7新增) ...

1
Analytic functions are the last set of operations performed in a query except for the final ORDER BY clause. 除了ORDERBY(按…排序)语句外,分析函数是一条查询被执行的操作。
2
An index will be used for both an ascending and a descending ORDER BY, whether the index was ascending or descending. 不管索引是升序排列还是降序排列,在执行升序或降序ORDERBY操作时都会使用索引。
3
Therefore, you may often choose to implement indexes that include only the columns referred to in the WHERE and ORDER BY clauses. 因此,您常常可以选择实现只包括在WHERE和ORDERBY子句中引用到的列的索引。
4
Most versions of SQL require that ORDER BY items appear in the select list, but Adaptive Server Anywhere has no such restriction. 大多数SQL版本都要求ORDERBY项出现在选择列表中,但AdaptiveServerAnywhere没有这样的限制。
5
Indexes are automatically used to improve the performance of queries issued to the database, and to sort queries with an ORDER BY clause. 索引自动用于改进向数据库发出的查询的性能,以及通过ORDERBY子句对查询排序。
6
There can be only one ORDER BY or COMPUTE clause after the last SELECT statement; it is applied to the final, combined result set. 而只能在最后一个SELECT语句的后面使用一个ORDERBY或COMPUTE子句;该子句适用于最终的组合结果集。
7
Indicates that the data column is being used to order the query results (is part of an ORDER BY clause ) . 表示数据列用于排序查询结果(ORDERBY子句的一部分)。
8
Using queries as the target of a data change operation allows deletion or updates of rows determined by complex SQL including ORDER BY. 通过使用作为数据更改操作的目标的查询,可以删除或更新由复杂的SQL(包括ORDERBY)确定的行。
9
An OLAP function can be included in expressions in a select-list or the ORDER BY clause of a select-statement. OLAP函数可以包括在一个select列表的表达式中或select语句的ORDERBY子句中。
10
This query is just like the previous one but with ORDER BY added to ensure that the first record in id order will be returned. 这个查询和之前那个差不多,只是加上了ORDERBY来保证以id号排序的第一个记录会返回。
11
And, once we begin using the RANDOM option, we must be very careful to code both a GROUP BY and an ORDER BY when order matters. 而且,一旦我们开始使用RANDOM选项,我们必须在排序至关重要时非常小心地编写GROUPBY和ORDERBY。
12
The first query specification of the UNION is used to determine the names to be matched with the ORDER BY clause. UNION的第一个查询说明用于确定与ORDERBY子句匹配的名称。
13
This limits the total size of columns specified in an ORDER BY clause. 这限制了在ORDERBY子句中指定的列的总大小。
14
It cannot be used within the individual queries that make up the statement. 不能在构成语句的各个查询中使用ORDERBY。
15
The index on the outermost table can be used to return rows in the order of the ORDER BY clause, eliminating the need for a sort. 可以用最外面的表上的索引,以ORDERBY子句的次序返回行,从而消除排序的需要。
16
Like in a regular ORDER BY clause multiple columns can be specified in either ascending or descending sequence. 类似于在常规的ORDERBY子句中,可以按升序或降序指定多个列。
17
The result sets of SELECT statements with a GROUP BY clause and no ORDER BY clause are sorted by the GROUP BY columns. 带GROUPBY子句但不带ORDERBY子句的SELECT语句的结果集,将按GROUPBY列排序。
18
Specifies whether columns in an ORDER BY clause must be in the select list. 指定ORDERBY子句中的列是否必须在选择列表中。
19
Similarly, if table names are aliased in the FROM clause, only the alias names can be used to qualify their columns in the ORDER BY clause. 同样,如果表名已在FROM子句中有了别名,则ORDERBY子句中只能使用别名来限定它们的列。
20
Omit the ORDER BY clause if you do not need the result set to be ordered. 如果不需要对结果集进行排序,则省略ORDERBY子句。
21
The "let" statement is itself composed of a FLWOR (for, let, where, order by, and return) XQuery expression. “let”语句本身由一个FLWOR(for、let、where、orderby和return)XQuery表达式组成。
22
The exact results of a UNION operation depend on the collation chosen during installation and the ORDER BY clause. UNION运算的准确结果取决于安装过程中选择的排序规则和ORDERBY子句。
23
ORDER BY guarantees a sorted result only for the outermost SELECT statement of a query. ORDERBY只保证查询的最外面的SELECT语句的排序结果。
24
Aggregate functions are allowed only in the select list and in the HAVING and ORDER BY clauses of a SELECT statement. 只能在SELECT语句的选择列表和HAVING和ORDERBY子句中使用集合函数。
25
The component SELECT statements must each have the same number of items in the select list, and cannot contain an ORDER BY clause. 各构成的SELECT语句在选择列表中必须有相同的项目数,并且不能包含ORDERBY子句。
26
Insertions are done in an arbitrary order unless the SELECT statement contains an ORDER BY clause. 除非SELECT语句包含ORDERBY子句,否则插入以任意顺序进行。
27
The ORDER BY clause can include items that do not appear in the select list. ORDERBY子句可包含未显示在选择列表中的项。
28
The exact results of an ORDER BY clause depend on the collation of the columns being ordered. ORDERBY子句的准确结果取决于被排序的列的排序规则。
29
With the appropriate access path, the ORDER BY or GROUP BY requirement can be met without sorting. 使用恰当的访问路径,无需排序即可满足ORDERBY或GROUPBY需求。
30
Option to a SELECT statement and using an appropriate ORDER BY clause to create an ordered data file . 语句将源表中的数据大容量导出,同时使用适当的ORDERBY子句创建有序的数据文件。