SQL 按特定字段值排序
<p>id, name<br>
shandong01 name1<br>
shandong02 name2<br>
shandong03 name3<br>
beijing01 name4<br>
beijing02 name5<br>
beijing03 name6<br>
shanghai01 name7</p>
<p class="codetitle">
<span><u>复制代码</u></span> 代码如下:</p>
<p class="codebody">
<br>
select id,name<br>
from table<br>
order by case when id like 'shanghai%' then 0 when id like 'beijing%' then 1 else 2 end</p>
<p>
<br><strong>result:</strong><br>
shanghai01 name7<br>
beijing01 name4<br>
beijing02 name5<br>
beijing03 name6<br>
shandong01 name1<br>
shandong02 name2<br>
shandong03 name3</p>
頁:
[1]