Re-applying a sort and/or filter is useful after making changes to the data or after selecting to turn the sort/filter off.
To reapply your last sort and/or filter to the data in a Browser window:
On the TABLE tab, in the Sort and Filter group, click Re-Sort.
This only applies to queries from within the Browser window, and does not apply to map layers that were built from a query window or to queries made from SQL Select operations.