数据分类 前Ｎ条

[liaoyukun111]

大概有一个这样的表
cid names,types
第三个字段是分类　　
求第一分类的前Ｎ条数据　　cid不一定连续

[liaoyukun111]

是每一个的分类的前Ｎ条

[htl258_Tony]

select * from tb t where cid in(select top n cid from tb where types=t.types order by cid)

[htl258_Tony]

--2005

select * from (select rn=row_number()over(partition by types order by cid),* from tb) t where rn<=n

[chuifengde]

SELECT * FROM @a a WHERE cid in(SELECT TOP 3 htrq FROM @a WHERE types=a.types ORDER BY cid)

[水族杰纶]

select * 
from tb t 
whre (select count(*)from tb where types=t.types and cid>t.cid)<3

[水族杰纶]

[Quote=引用 5 楼 wufeng4552 的回复:]
SQL code
select *
from tb t
where (select count(*)from tb where types=t.types and cid>t.cid)<3
[/Quote]

select * 
from tb t 
where (select count(*)from tb where types=t.types and cid>t.cid)<3

[luo7269315]

不懂。。。学习学习。。。