Sort by criteria with values from different columns

Sometimes the requirements for sorting are more complex, such as: Leaders are more interested in employees who pay between 1000 and 2000, so employees in this range are required to be in front of them in order to prioritize.

To create a test table:

CREATE OR REPLACE VIEW v asselect ' MARTIN ' as ename, 950 as Sal from Dualunion allselect ' werd ' as ename, 1250 as Sal from Dualunion allselect ' Terner ' as ename, as Sal from Dualunion allselect ' ALLEN ' as ename, and as Sal from Dualunion Allselect ' JAMES ' as ename, 2850 as Sal from DUAL; SELECT * from V;

The SQL code is as follows:

SELECT * from v ORDER by case when Sal between and 1 then ELSE 2 END, Sal;

The results of the implementation are as follows:

Sort by criteria with values from different columns