关于一个SQL语句

bai314803137 2010-01-27 09:55:39

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

...全文

73 8 打赏收藏转发到动态举报

写回复

用AI写文章

8 条回复

切换为时间正序

请发表友善的回复…

发表回复

戒烟戒酒戒编程 2010-01-27

打赏
举报

手快啊

bai314803137 2010-01-27

打赏
举报

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

雷问X 2010-01-27

打赏
举报

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

yan267 2010-01-27

打赏
举报

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

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

and LBone=1 and LBmenId=0???

junshanhudazhaxi 2010-01-27

打赏
举报

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

bai314803137 2010-01-27

打赏
举报

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

mxc1225 2010-01-27

打赏
举报

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

直接加上去试试!?!

hw55912346 2010-01-27