关于一个SQL语句

[bai314803137]

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 我不知道怎么加了 请各位大侠帮帮忙

[hw55912346]

没整明白 你到底想干什么

[mxc1225]

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 

直接加上去试试!?!

[bai314803137]

意思就是 最后的查询条件是LBone=1 LBmenId=0

[junshanhudazhaxi]

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

[yan267]

and LBone=1的后面 加一个条件 是LBmenId=0

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


and LBone=1 and LBmenId=0???

[雷问X]

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的话，可以使用：

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 30

[bai314803137]

谢谢各位帮忙 2楼的哥哥最快 谢谢他了

[戒烟戒酒戒编程]

手快啊