Page History

The REORDER command allows you physically reorder a table by a different sort order. This can be useful it you want to go through a table record by record.
Syntax:
REORDER TABLE \[TABLE NAME\] BY column1 (optional desc),…, columnN (option desc)
\\
Example:   REORDER TABLE orders by ORDERID Desc