absolute 1st or last order

[dotJoon]

data in myTable1

(ID) name
(1) Tom 
(2) Jane 
(3) Jack 
(4) Mary 
(5) Ted

I have data in myTable1 like the above.
Because (3) Jack is a kind of sticky, I like to make jack comes first or last.

The following would-be code is one of my trials.
But it seems to be not work as I want.

would be code

select id, name, CASE WHEN id = '3' THEN 1 ELSE 2 END AS ORDER_KEY 
from myTable1 
order by ORDER_KEY, id 
 
target result

(3) Jack
(1) Tom 
(2) Jane  
(4) Mary 
(5) Ted

[guido2004]

But it seems to be not work as I want.

Why? What happens? An error? Not the expected output (if so, what output do you get) ?


And did you think about adding a 'sticky' column to your table?

[dotJoon]

Why? What happens? An error? Not the expected output (if so, what output do you get) ?

Sorry, I made a mistake. Maybe it was Capital letters and Small letter problems.
Now I got my target result.

Thank you very much, guido2004.