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.
REORDER TABLE [TABLE NAME] BY column1 (optional desc),…, columnN (option desc)
REORDER TABLE orders by ORDERID Desc
Please sign in to leave a comment.