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;