¹ØÓÚÒ»¸öSQLÓï¾ä

select top 15 * from LBBrandInfo where LBid not in (select top 15 LBid from LBBrandInfo where LBmenId=0 and LBone=1 order by LBid desc) and LBone=1 and order by LBid desc

ÎÒ»¹ÏëÔÚÍâΧ¼ÓÒ»¸öÌõ¼þ ¾ÍÊÇÔÚdesc) and LBone=1µÄºóÃæ ¼ÓÒ»¸öÌõ¼þ ÊÇLBmenId=0 ÎÒ²»ÖªµÀÔõô¼ÓÁË Çë¸÷λ´óÏÀ°ï°ïæ

---

ûÕûÃ÷°×  Äãµ½µ×Ïë¸Éʲô

---

Òâ˼¾ÍÊÇ ×îºóµÄ²éѯÌõ¼þÊÇLBone=1 LBmenId=0

---

select top 15 * from LBBrandInfo where LBid not in (select top 15 LBid from LBBrandInfo where LBmenId=0 and LBone=1 order by LBid desc) and LBmenId=0 and LBone=1 and order by LBid desc

---

and LBone=1µÄºóÃæ ¼ÓÒ»¸öÌõ¼þ ÊÇLBmenId=0

and ( LBone=1 or LBmenId=0)???


and  LBone=1 and LBmenId=0???

---

SQL code:
select top 15 * from LBBrandInfo where LBid not in (select top 15 LBid from LBBrandInfo where LBmenId=0 and LBone=1 order by LBid desc) and LBone=1 and LBmenId=0 order by LBid desc
²»¾ÍÐÐÁË£¿£¿
ÄãÏëÈ¡µÚ¶þÒ³µÄ15Ìõ¼Ç¼£¿£¿Èç¹ûÄãÊÇSQL 2005µÄ»°£¬¿ÉÒÔʹÓãº
SQL code:

with PageTable as (select ROW_NUMBER() over (order by Member_UserID) 'RowNumber'£¬* from LBBrandInfo where LBmenId=0 and LBone=1 order by LBid desc) select * PageTable from where where RowNumber Between 16 and