Thread: help with query
View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 09:50 AM
Aahz
 
Posts: n/a
Default help with query

select number,name,age,address from people
where number in (88,4,2,6,8,1,166,33)

How I make this to have order by exact numbers as in query. I want
result to be ordered like this:

88
4
2
6
8
1
166
33

and not

1
2
4
......etc

and not by name or anything else

How to do this ? Thank you

Reply With Quote