sql·ÖÒ³ÎÊÌâ - .NET¼¼Êõ / ASP.NET

select top 3 stuid from pagesize where stuid not in (select top 3 stuid from pagesize order by id asc) order by id ascÕâÀïµÄ·ÖÒ³sqlÓï¾äΪʲôҪ¼ÓÉÏÅÅÐòÄØ£¿²»ÅÅÐò²»ÐÐÂð£¿ÎÒ¿´µ½ºÜ¶àsqlÓï¾ä·ÖÒ³´úÂëÔÚÀ¨ºÅÍâÃæºÍÀïÃ涼ÓÐÅÅÐò£¡ÄܾßÌå˵ÏÂʲôÂ𣿻òÕßÓÐÆäËûµÄÀý×ÓÀ´ËµÒ»Ï£¡£¿£¿
id stuid
1 1
2 2
3 2
4 2
5 2
6 5
7 6
8 7
9 8
10 8
11 9
12 10//¶ÔÓÚÕâ¸ö±ísqlÓï¾äselect top 3 stuid from pagesize where stuid not in (select top 3 stuid from pagesize order by id asc) order by id asc ΪʲôÊä³öµÄ²»ÊÇ2,2,5ÄØ£¿

---

Èç¹ûÊǵ¹ÐòµÄ»° À¨ºÅÍâÃæºÍÀïÃ涼Ҫ¼ÓÉÏÅÅÐò ÒòΪÊÇ·´ÆðÀ´µÄ
ĬÈÏÅÅÐò·½Ê½ÊÇasc ÄãÕâ¸ö²»¼ÓÅÅÐòÒ²ÊÇÕýÈ·µÄ

---

ÓÃorder byÊDZ£Ö¤×Ó²éѯºÍÍâÃæµÄÖ÷²éѯ¿´µ½µÄÊÇ¡°Í¬Ò»ÕÅ±í¡±£¨¼Ç¼˳ÐòÏàͬ£©£¬ÕâÑù²ÅÄÜ´ïµ½·ÖÒ³µÄЧ¹û¡£

Ö÷²éѯµÄ top 3 ±íʾѡÔñ3Ìõ¼Ç¼£¨Ã¿Ò³¼Ç¼Êý£©£¬×Ó²éѯµÄ top 3 ±íʾÌø¹ýµÄ¼Ç¼Êý£¨Ò³ºÅ*ÿҳ¼Ç¼Êý£©

·ÖÒ³²éѯӦµ±ÓÃÖ÷¼üid£¬²»Ó¦µ±ÓÃstupid£¬ÒòΪËüÓÐÖظ´¼Ç¼ÏÔÈ»²»ÊÇÖ÷¼ü

---

ÒýÓÃ

¶ÔÓÚÕâ¸ö±ísqlÓï¾äselect top 3 stuid from pagesize where stuid not in (select top 3 stuid from pagesize order by id asc) order by id asc ΪʲôÊä³öµÄ²»ÊÇ2,2,5ÄØ£¿

Êä³ö²»ÊÇ2£¬2£¬5Âð£¿

---

SELECT TOP Ò³´óС *
from TestTable
WHERE (ID NOT IN
  (SELECT TOP Ò³´óС*Ò³Êý id
  from ±í
  ORDER BY id))
ORDER BY ID

SELECT TOP Ò³´óС *
from TestTable
WHERE (ID >