求一sql语句怎么写或者存储过程怎么写？

[pawin]

表一 company

id name
1 IBM
2 惠普
3 联想
4 东芝
. .
. .
. .


表二 news

nid comid title
1 1 computer
2 1 notbook
3 2 hard
4 2 pc
. . .
. . .
. . .

表一id和表二comid关联。表一的id和表二的nid都是主键，自增。

要求选出 表二news的前100条记录，其中comid相同的，只能读前3条记录

不知道sql语句怎么写或者存储过程怎么写？

我是很菜的鸟，请高手帮忙帮忙

[中国风]

select * from  news  b 
where (select count(1) from news where comid=b.comid and ID!>b.ID)!>3

[dawugui]

--方法一
select * from (select a.* from news a,company b where a.id = b.comid) t
where nid in
(
select top 3 nid from (select a.* from news a,company b where a.id = b.comid) m where comid=t.comid order by nid
)

--方法二
select * from (select a.* from news a,company b where a.id = b.comid) t
where (select count(*) from (select a.* from news a,company b where a.id = b.comid) m where comid = t.comid and nid < t.nid) < 3

[you_tube]

select top 100 * from (select * news, company where news.id = company.comid) t
where nid in
(
select top 3 nid from (select * from news,company where news.id = company.comid) m where news=t.comid order by nid)
)