3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
萧华璋 2007-12-21
谢谢.
wzy_love_sly 2007-12-21
哈哈，未卜先知啊
pt1314917 2007-12-21
:)
wzy_love_sly 2007-12-21
5楼和你的表结构一样，改
cloudfang 2007-12-21
JF
pt1314917 2007-12-21
select * from 信息表 a where infoId in (select top 2 infoId from 信息表 where sortId=a.sortId and isnull(picture,'')!='' order by infoId desc )--为图片时
union
select * from 信息表 a where infoId in (select top 8 infoId from 信息表 where sortId=a.sortId and isnull(picture,'')='' order by infoId desc )--非图片
wzy_love_sly 2007-12-21
漫步好仔细啊 呵呵
萧华璋 2007-12-21
我的表结构是
信息表:
infoId
sortId
infoTitle
picture
信息表:
infoId
sortId
infoTitle
picture
pt1314917 2007-12-21
搞错：
select * from 表名 a where id in (select top 2 id from 表名 where 栏目=a.栏目 and 图片=1 order by id)--为图片时
union
select * from 表名 a where id in (select top 8 id from 表名 where 栏目=a.栏目 and 图片!=1 order by id)--非图片
pt1314917 2007-12-21
还要是每个栏目都取。1楼似乎掉了
pt1314917 2007-12-21
select * from 表名 a where exists(select top 2 * from 表名 where 栏目=a.栏目 and 图片=1)--为图片时
union
select * from 表名 a where exists(select top 8 * from 表名 where 栏目=a.栏目 and 图片!=1)--非图片
awfer1 2007-12-21
ls正解
wzy_love_sly 2007-12-21
select * from table where id in(select top 2 * from table whre type='图片' ordery by newid())
union
select * from table where id in(select top 8 * from table whre type='别的' ordery by newid())
union
select * from table where id in(select top 8 * from table whre type='别的' ordery by newid())