¹ØÓÚASPÀûÓÃSQLÓï¾ä¼¼ÇÉ·ÖҳЧ¹û
ÎÒÊÇÕâÑùдµÄ
select top 5 * from city where id not in(select top (5*"&page-1&") id from city) ..
ºÜʧ°ÜµÄ »¹ÒªÏÈÅжÏÊDz»ÊǵÚÒ»Ò³ È»ºóÑ¡ÔñÐÔÖ´ÐÐ sql .. д×Åд×ÅÎÒ¾õµÃÕâÑùд¸úÖ±½Ó·ÖÒ³ÊÇûʲôÇø±ðµÄ ? ¶¼¸øSQL
ÖÆÔìÁ˲»Ð¡µÄ¹¤×÷Á¿ .. ÌØ´ËÌù³öÀ´ ¿´¸÷λ´óÏÀÃÇʱ³£ÕâÖÖ¼¼ÇÉ·ÖÒ³ÊÇÔõô×öµÄ!! ÕâÑùдÕýÈ·²» ?
¸ßÈ˶¼ÄÄÈ¥ÁË°¡ £¿
top ****not in ***
SELECT TOP 10 *
from TestTable
WHERE (ID NOT IN
(SELECT TOP 20 id
from TestTable
ORDER BY id))
ORDER BY ID
·Ïµ° ÎÒ¶¼Ð´³öÀ´ÁË »¹ÒªÄãдһ±é¸Éʲô £¿ Äãµ¹ÊDzûÊöÒ»ÏÂÔÀí ¡£¡£ ÕâÑù¸úÖ±½ÓÓÃRS·ÖÒ³ÓÐʲô²»Í¬£¡
Ïà¹ØÎÊ´ð£º
±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½Ãæȥѧϰ
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
Ò»¶Îʱ¼äºó ¾Í²»ÄÜÓõÄÄÇÖÖ
¿ÉÒÔÓÃ×é¼þдÂð?
×é¼þ ÊDz»ÊDZØÐëÏÈÔÚ·þÎñÆ÷°²×° ²ÅÄÜʹÓÃ?
ÄÇÓÃÐéÄâÖ÷»úµÄ ²»¾ÍûϷÁË....
ewebeditor¾ÍÊÇҪע²á²ÅÄÜÓõÄ
òËÆÊÇûɶÓõ ......
ÓÐËÄܸø½²½²£¬Ôõô×öÂð£¿
ллÀ²£¡
¸ÊÌØͼ ÊÇɶ£¿
½âÌâ˼·.¿´Ò»Ï½ø¶ÈÌõµÄÏÔʾ..
ÆäʵÄã¾ÍŪһ¶Ñtable ÿ¸ötableµÄ¿í¶È²»Í¬.µ×É«²»Í¬¼´¿É
µ±È»ÓÃdiv¿ØÖÆλÖøüºÃ
ÄãŪ100¸ötable¸ù¾Ý½ø¶ÈÆäÖÐÇ°20¸ö·Ö¸øµ ......