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>整理别人的sql</P>
<P>大概的思想是用union 和union all </P>
<P>--合并重复行<BR>select * from A<BR>union <BR>select * from B</P>
<P><BR>--不合并重复行<BR>select * from A<BR>union all<BR>select * from B</P>
<P><BR>按某个字段排序<BR>--合并重复行<BR>select *<BR>from (<BR>select * from A<BR>union <BR>select * from B) AS T<BR>order by 字段名</P>
<P>--不合并重复行<BR>select *<BR>from (<BR>select * from A<BR>union all<BR>select * from B) AS T<BR>order by 字段名</P>
<P>//sql server版<BR>Select * From (<BR>select top 2 id,adddate,title,url from bArticle where ClassId='1' order by adddate desc) A<BR>Union All<BR>Select * From (<BR>select top 2 id,adddate,title,url from bArticle where ClassId='2' order by adddate desc) B<BR>Union All<BR>Select * From (<BR>select top 2 id,adddate,title,url from bArticle where ClassId='3' order by adddate desc) C<BR>Union All<BR>Select * From (<BR>select top 2 id,adddate,title,url from bArticle where ClassId='4' order by adddate desc) D</P>
<P><BR>//mysql版<BR>Select * From (<BR>select id,adddate,title,url from bArticle where ClassId='1' order by adddate desc limit 0,2) A<BR>Union All<BR>Select * From (<BR>select id,adddate,title,url from bArticle where ClassId='2' order by adddate desc limit 0,2) B<BR>Union All<BR>Select * From (<BR>select id,adddate,title,url from bArticle where ClassId='3' order by adddate desc limit 0,2) C<BR>Union All<BR>Select * From (<BR>select id,adddate,title,url from bArticle where ClassId='4' order by adddate desc limit 0,2) D<BR><A title="" href="http://blog.csdn.net/kemy88/archive/2007/02/28/1516913.aspx" target=_blank>http://blog.csdn.net/kemy88/archive/2007/02/28/1516913.aspx</A></P></SPAN><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>