摘要：
（1）order byORDER BY子句的语法为：SELECT column1, SUM(column2) FROM "list-of-tables"ORDER BY "column-list" [ASC | DESC];[ ] = optionalORDER BY是一个可选的子句，它允许你根据指定要order by的列来以上升或者下降的顺序来显示查询的结果。例如：ASC = Ascending Order –这个是缺省的DESC = Descending Order下面举个例子：SELECT employee_id, dept, name, age, 阅读全文