SQL ORDER BY

    ORDER BY 关键字用于对结果集进行排序。

SQL ORDER BY 关键字

    ORDER BY 关键字用于对结果集按照一个列或者多个列进行排序。 

    ORDER BY 关键字默认按照升序对记录进行排序。如果需要按照降序对记录进行排序，您可以使用 DESC 关键字。

SQL ORDER BY 语法

  SELECT column_name,column_name FROM table_name ORDER BY column_name,column_name ASC|DESC;

实例

SELECT * FROM Websites ORDER BY alexa;

SELECT * FROM Websites ORDER BY alexa DESC;

SELECT * FROM Websites ORDER BY country,alexa;