如何查询前n条记录

[xujianfu]

有一个表News
id type name
1 1 a
2 2 b
3 2 c
4 2 d
5 3 e
6 3 f
7 3 g
怎样把news中按照type查找出没种记录的前2条记录
即
id type name
1 1 a
2 2 b
3 2 c
5 3 e
6 3 f

[fcuandy]

select * from [news] a where 2>(select count(1) from [news] b where b.id<a.id and b.type=a.type)

这种问题也天天有人问。

[子陌红尘]

select
n.*
from
news n
where
n.id in(select top 2 id from news where type=n.type order by id)

[LouisXIV]

select *
from News a
where 2>(select count(1) from News where type=a.type and id<a.id)

[LouisXIV]

一百遍啊一百遍

^^;

[xujianfu]

收到 谢谢