SQLite 3.39

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (a int not null, b int not null, primary key(a,b))
✓
insert into t (a,b) values (1,1),(1,2),(1,3),(2,4),(2,5),(2,6)
✓
select a,b from t order by a, case when a%2=1 then 1 else -1 end * b


a
b


1
1

1
2

1
3

2
6

2
5

2
4


select a,b from t order by a, coalesce(nullif(a%2=1,0),-1)*b


a
b


1
1

1
2

1
3

2
6

2
5

2
4


create table tt (a int not null, b char(5) not null, primary key(a,b));
✓
insert into tt (a,b) values (1,'a10'),(1,'2b0'),(1,'30c'),(2,'a10'),(2,'2b0'),(2,'30c')
✓
select a, b from tt order by a
     , case when a%2=1 then '0' else b end 
     , case when a%2=0 then '0' else b end desc


a
b


1
a10

1
30c

1
2b0

2
2b0

2
30c

2
a10