如何输出列ArticleViews中值最高的前5个结果?

本文关键字：5个 结果 何输出 输出 ArticleViews | 更新日期: 2023-09-27 18:03:14

下面是我的数据源。

<asp:SqlDataSource ID="getbyviews" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectAntiFrack %>" 
SelectCommand="SELECT [ArticleID], [ArticleTitle], [ArticlePublished], [ArticleViews] 
FROM [ArticlesTBL] 
WHERE ([ArticlePublished] = @ArticlePublished) 
ORDER BY [ArticleViews] DESC">
<SelectParameters>
<asp:Parameter DefaultValue="True" Name="ArticlePublished" Type="Boolean" />
</SelectParameters>
</asp:SqlDataSource>

是否有一种方法来操纵select语句，只抓取5个最高的结果?或者这可以在c#中完成吗?我的数据源稍后将用于填充listview。

如何输出列ArticleViews中值最高的前5个结果?

就用TOP 5:

SELECT TOP 5 [ArticleID], [ArticleTitle], [ArticlePublished], [ArticleViews] 
FROM [ArticlesTBL] 
WHERE ([ArticlePublished] = @ArticlePublished) 
ORDER BY [ArticleViews] DESC
相关文章：