how to get some records in first row in sql
<p>I have q query like this: </p>

<pre><code> Select  WarehouseCode  from [tbl_VW_Epicor_Warehse]
</code></pre>

<p>my output looks like this</p>

<pre><code>WarehouseCode
Main
Mfg
SP
W01
W02
W03
W04
W05
</code></pre>

<p>But sometimes I want to get W04 as the first record, sometimes I want to get W01 as the first record .</p>

<p>How I can write a query to get some records in first row??<br>
Any help is appreciated</p>