谁能告诉我这个怎么才可以实现,线上等!!!!!!
select top 6 id,title from Titles Where (Id3=10 or Id3=11) and Pass=1 order by addtime desc
原来是这样的
无论Id3=10 还是Id3=11都是出自一章表..现在要求是,
当等于10的时候取3条记录.当等于11的时候取3条记录
然后查出结果,我要数据绑定,,所以还必须是一个select语句实现
我老大说用group..可是我没有思路也没有做过...
请各位大虾帮忙,,,在线等!
[解决办法]
select * from (select top 3 id,title from Titles Where Id3=10 and Pass=1 order by addtime desc) T1
union all
select * from (select top 3 id,title from Titles Where Id3=11 and Pass=1 order by addtime desc) T2
[解决办法]
select * from(
select top 3 id,title from Titles where Id3=10 order by addtime desc)a
union all
select * from(
select top 3 id,title from Titles where Id3=11 order by addtime desc)b
