Sort values in different columns based on conditions.

Sort values in different columns based on conditions.

Sometimes the ordering requirements are complex. For example, if a leader is more interested in employees with salaries between 1000 and 2000 yuan, the employees with salaries in this range must be at the top, for priority.

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, 1500 AS sal from dualunion allselect 'allen 'AS ename, 1600 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 1000 AND 2000 THEN 1 ELSE 2 END, sal;

The execution result is as follows: