asp.net·ÖÒ³ÎÊÌâ

select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Product) where productid=34
·ÖÒ³¾ÍʧЧÁË
Êý¾ÝÈ«ÊÇÇ°12Ìõ

---

ÊÇÓÃʲô¿Ø¼þ·ÖÒ³ÏÔʾÊý¾Ý,ÓÐЩ¿Ø¼þ²»ÊÇ×Ô´ø·ÖÒ³¹¦ÄÜô.

---

¸Ä³É
SQL code:
select top 12 * from Product where [id] not in (select top 12 [id] from Product where productid=34) and productid=34

---

ÒýÓÃ

¸Ä³É
SQL codeselecttop12*from Productwhere[id]notin (selecttop12[id]from Productwhere productid=34)and productid=34

¶¥Õâ¸ö
Â¥Ö÷µÄSQLÓï¾äÀïÃæÉÙÁ˸öÌõ¼þ

---

лÁË ½â¾öÁË ºÇºÇ ȷʵÊÇÉÙÁ˸öÌõ¼þ

---

select top 12 * from Product where [id] not in (select top 12 [id] from Product) where productid=34,Ó¦¸Ã¿¼ÂÇÖ´ÐÐ˳Ðò¡£
SQL code:
select top 12 * from Product where [id] not in (select top 12 [id] from Product) and productid=34

»òÕßSQL code:
select top 12 * from Product where [id] not in (select top 12 [id] from Product where productid=34£©