Oracle sorts specific information for a column [decode], oracle sorts decode

Oracle sorts specific information for a column [decode], oracle sorts decode

In ORACLE queries, if there is no sorting, but you want to route the information of a specific value in a column to the front, use the decode (field, 'field value', number) of oracle)

For example, if you want to forward the result of name = 'zhang san' to the front of all data queried by select name from user, use the following:

Select name from user order by decode (name, 'zhang san', 0)

Similarly, if you want Li Si to rank second, you can continue to add the decode method.

Select name from user order by decode (name, 'zhang san', 0), decode (name, 'Li si', 1)