--获取每家公司前一百条新闻的ID
select a.WebNewsID from WebNews as a
where a.WebNewsID in (select top 100 WebNewsID
from WebNews where Code=a.Code
order by PageGetTime desc)
group by a.WebNewsID,a.Code order by a.Code
select a.WebNewsID from WebNews as a
where a.WebNewsID in (select top 100 WebNewsID
from WebNews where Code=a.Code
order by PageGetTime desc)
group by a.WebNewsID,a.Code order by a.Code