TSQL sorting issues

Question

Hello!

I know that order by can be used for sorting, and adding desc can be used to sort in descending order.

But now I need to move some of the last values to the middle, how do I do that?

Answer 1

Hi @15431565

You can use the case when statement in the order by.

Just like this.

create table test(col int);
insert into test values(4),(20),(36)
select * from test order by case when col = 4 then 1
                                 when col = 20 then 3
								 when col = 36 then 2 end;

Output:

Best regards,

Percy Tang