如何为表中某列的给定值选择最多N条记录?

CTE很简单。

;with x as 
(
    select ID, LanguageID, Title, Date,
            row_number() over ( partition by LanguageID order by Date DESC  ) as position
    from NewsArticles
)
select * from x 
where Position < 6

CREATE VIEW Top5Articles
AS     
    SELECT top 5 * FROM LatestNews WHERE LanguageID = 1 order by createdontime desc // latest 5 English news articles
    union
    SELECT top 5 * FROM LatestNews WHERE LanguageID = 2 order by createdontime desc
    union
    SELECT top 5 * FROM LatestNews WHERE LanguageID = 3 order by createdontime desc

假设您有一个created on time列,其中的文章是按时创建的。

union将把所有选择返回到一个结果集中。

你想要这样的东西吗-

select *
from LatestNews
where (
   select count(*) from LatestNews as A
   where A.LanguageID = LatestNews.LanguageID 
) <= 5 order by Date DESC;