对行进行分类

ORDER BY子语句用于对行进行排序。

Orders:

实例

以字母顺序显示公司名称：

SELECT Company, OrderNumber FROM OrdersORDER BY Company

结果：

实例

以字母顺序显示公司名称（Company），并以数字顺序显示顺序号（OrderNumber）：

ELECT Company, OrderNumber FROM OrdersORDER BY Company, OrderNumber

结果：

实例

以逆字母顺序显示公司名称：

SELECT Company, OrderNumber FROM OrdersORDER BY Company DESC

结果：

实例

以逆字母顺序显示公司名称，并以数字顺序显示顺序号：

SELECT Company, OrderNumber FROM OrdersORDER BY Company DESC, OrderNumber ASC

结果：

注意：在以上的结果中有两个相等的公司名称(W3School)。只有这一次，在第一列中有相同的值时，第二列是以升序排列的。如果第一列中有些值为nulls时，情况也是这样的。

-------------------------------------------------------------------------------------------------------------------------------------------------------

SELECT * FROM PersonsWHERE FirstName='Tove'AND LastName='Svendson'

SELECT * FROM PersonsWHERE firstname='Tove'OR lastname='Svendson'

SELECT * FROM Persons WHERE(FirstName='Tove' OR FirstName='Stephen')AND LastName='Svendson'

SELECT column_name FROM table_nameWHERE column_name IN (value1,value2,..)

SELECT * FROM PersonsWHERE LastName IN ('Hansen','Pettersen')

SELECT column_name FROM table_nameWHERE column_nameBETWEEN value1 AND value2

SELECT * FROM Persons WHERE LastNameBETWEEN 'Hansen' AND 'Pettersen'

SELECT * FROM Persons WHERE LastNameNOT BETWEEN 'Hansen' AND 'Pettersen'

SELECT column AS column_alias FROM table

SELECT column FROM table AS table_alias

SELECT LastName AS Family, FirstName AS NameFROM Persons

SELECT LastName, FirstName FROM Persons AS Employees