order的用法ORDER BY的使用

in order 的意思和用法？

从句型分析 in order to + 动词 in order that + 从句 in order可用于句首，in order to/that一般不用于句首 意思分析 in order:整齐 in order to:为了

in order to的用法

不定式可以表示目的状语，直接用【to do 】表示。

其强调形式有： so as to do (只能放在句中，不能位于句首) in order to do(及可以放在句首，也可位于句中) 例如： We started early 【to catch 】the first bus to the Great Wall. =【In order to catch】 the first bus to the Great Wall,we started early. =We started early 【so as to/in order to catch】 the first bus to the Great Wall. =We started early 【so that/in order that we could】 catch the first bus to the Great Wall. *so that/ in order that(引导目的状语从句)

ORDER BY的使用

你的写法排序结果是：先按部门号降序排，再按单价升序排。

Order By 是支持多字段排序，写在前面的字段先排序。

还支持构造列排序。

比如下面这条语句就是按商品的销售合计金额降序排的： Select c.Code,Sum(c.Money) as Money From 销售明细 c Group Gy c.Code Order By Money Desc