ORDER BY子句 ORDER BY子句的语法为： SELECT column1, SUM(column2) FROM "list-of-tables" ORDER BY "column-list" [ASC | DESC]; [ ] = optional ORDER BY是一个可选的子句，它允许你根据指定要order by的列来以上升或者下降的顺序来显示查询的结果。例如： ASC = ...

We are halfway though many of our applications switching from Access to SQL Server (my idea to deal with the fact many of our applications are locking each other out / thrashing every 8-10 min ...