摘要:
(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, 阅读全文