How to Put condition in order by sql Query

Question

This is my table name :- xyztable and in this table i have 3 column

A:- id
B:- Name
c:- Order_number

i have a sample data like

Id Name order_nmber  
1  A    1  
2  K    0  
3  B    6  
4  c    3  
5  P    0  
6  d    5  
7  e    2  
8  O    0  

I wrote the query is

select  * from xyztable order by order_number ASC;

that give me the result is

Id Name order_nmber 
2  K    0
5  P    0
8  O    0
1  A    1
7  e    2
4  c    3 
6  d    5
3  B    6 

But i want the result like :-

Id Name order_nmber 
1  A    1
7  e    2
4  c    3 
6  d    5
3  B    6
2  K    0
5  P    0
8  O    0

So how can i get this in single query....Please help!!!!

Answer 1

You could do like below:

select  * from xyztable order by order_number = 0, order_number ASC;