title: Custom order in SQL
body: <p>We are querying database to retrieve data in following fashion</p>
  
  <p>select a,b,...f from table1 where id in (6,33,1,78,2)</p>
  
  <p>The result I got from query is in following order 1,2,6,33,78.</p>
  
  <p>I want the result in same order (6,33,1,78,2). Is there any way to retrieve the data in same order.</p>
  
  <p><strong>EDIT</strong>
  *<em>I am using SQL 2008</em>*</p>