The REORDER command allows you physically reorder a table by a different sort order. This can be useful ityou 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
Comments
Please sign in to leave a comment.