order
UK[??:d?(r)] US[??:rd?(r)]
n. Order; command; sequence; rule, System
vt. Order; order; organize
vi. Place an order
Third person singular: orders Plural: orders Present participle: ordering Past tense: ordered Past participle: ordered
by
英[ba?] 美[ba?]
prep.beside...;expression;because;through
adv. pass; used when expressing retention or preservation; short visit
mysql ORDER BY statement syntax
Function: Used to sort the result set.
Syntax: Order: SELECT * from table name ORDER BY sorted field name Reverse order: SELECT * from table name ORDER BY sorted field name DESC
Description: The ORDER BY statement is used to sort the result set based on the specified column. The ORDER BY statement sorts records in ascending order by default. If you want to sort records in descending order, you can use the DESC keyword.
mysql ORDER BY statement example
//以字母順序顯示公司名稱 SELECT Company, OrderNumber FROM Orders ORDER BY Company; //以字母順序顯示公司名稱(Company),并以數(shù)字順序顯示順序號(OrderNumber) SELECT Company, OrderNumber FROM Orders ORDER BY Company, OrderNumber; //以逆字母順序顯示公司名稱 SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC;