table align="left" cellpadding="0" cellspacing="0" border="0" >
<tr>
<td align="center"><script language='javascript' src='http://www.iTbulo.com/gg/200703/78.js'></script></td>
</tr>
</table><SPAN class=t18> 
<P>order by常用的使用方式我就不提了 </P>
<P>项目的需求千变万化 <BR>让我们看看下面几个怪排序需求 </P>
<P>--先创建一个表 <BR>create table ai( <BR>id int not null, <BR>no varchar(10) not null <BR>) <BR>go </P>
<P>--往表中插入数据 <BR>insert into ai <BR> select 105,'2' <BR> union all <BR> select 105,'1' <BR> union all <BR> select 103,'1' <BR> union all <BR> select 105,'4' <BR>go </P>
<P>--查询效果如下: <BR>select * from ai <BR>go <BR>id          no         <BR>----------- ---------- <BR>105         2 <BR>105         1 <BR>103         1 <BR>105         4 </P>
<P><BR>i. <BR>--要求的查询结果如下 <BR>--即要求no列的数据按'4','1','2'排列<BR>id          no         <BR>----------- ---------- <BR>105         4 <BR>105         1 <BR>103         1 <BR>105         2 </P>
<P> </P>
<P>--解决方案1 <BR>--利用函数CHARINDEX <BR>select * from ai <BR> order by charindex(no,'4,1,2') </P>
<P>--解决方案2,并且每组再按照id降序排列<BR>--利用函数case <BR>select * from ai <BR> order by case when no='4' then 1 <BR>        when no='1' then 2 <BR>                      when no='2' then 3 <BR>                 end,id desc</P>
<P><FONT color=#ff0000></p><p align='center'><b><font color='red'>[1]</font> <a href='http://edu.itbulo.com/200703/112305_2.htm'>[2]</a> <a href='http://edu.itbulo.com/200703/112305_2.htm'>下一页</a> </b></p><script language='javascript' src='http://www.iTbulo.com/gg/200703/79.js'></script></td>
</tr>
</table>
</td>
<td width="1" valign="top" bgcolor="#A8A8A8"></td>
<td width="173" valign="top" bgcolor="F3F3F3">
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="21" align="center" valign="middle" bgcolor="DFDFDF"><strong>文章搜索</strong></td>
</tr>
<tr>
<td height="2" bgcolor="A3A3A3"></td>
</tr>
<form method="Get" name="SearchForm" action="/Search.asp" target="_blank"><TR>
<TD height="40" align=center><input name="Field" type="hidden" id="Field" value="Title"><INPUT name=Keyword id="Keyword" size=16> <INPUT type=submit value=搜索 name=submit onClick="if(this.form.Keyword.value=='') {alert('请输入关键字');return false;}"></TD></TR></FORM>
<tr>
<td height="21" align="center" valign="middle" bgcolor="DFDFDF"><strong>