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>-前提是必需有一列是自动增长类型,唯一性</P>
<P>--方法一</P>
<P>SELECT DISTINCT TOP 8 CategoryID<BR>FROM tbl_Product_Products<BR>WHERE (UserID = 73) AND (CategoryID ><BR>          (SELECT MAX(categoryid)<BR>         FROM (SELECT DISTINCT TOP 16 categoryid<BR>                 FROM tbl_product_products where userid=73<BR>                 ORDER BY categoryid) AS b))<BR>ORDER BY CategoryID</P>
<P>--方法二</P>
<P>select top 10 * from [order details]<BR>where orderid>all(select top 10 orderid from [order details] order by orderid)<BR>order by orderid</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>