order
Sorts the specific fields to be printed out in the specified order, and displays the remaining fields in lexicographical order.
Syntax
order FIELD, ...
Required Parameter
FIELD, ...
- Names of fields to be ordered in order, separated by a comma (
,
). The command sorts the fields that are not listed here in lexicographical order.
Usage
-
Define the field output order of the
sys_cpu_logs
table as kernel, idle, user, _time, _table, and _id.table sys_cpu_logs | order kernel, idle, user, _time, _table, _id
-
Define the field output order of the
sys_cpu_logs
table as idle, kernel and then the rest in lexicographical ordertable sys_cpu_logs | order idle, kernel