单个字段
默认升序排列
SELECT * FROM Orders ORDER BY name1
降序排列
SELECT * FROM Orders ORDER BY name1 DESC
一个字段的排序按照升序或降序显示
两个字段排序
SELECT * FROM Orders ORDER BY name1, name2
//两个字段都按升序排列
两个字段都排序,第一个字段比第二个字段具有更高的优先级,例如:
SELECT * FROM Orders ORDER BY name1 DESC, name2 DESC
//降序,降序
name1降序排列后,若有相等的内容,则对应的name2降序排列