选择最长的10个帖子

Question

我正在尝试查看stackoverflow上最长的帖子，使用：

https://data.stackexchange.com/stackoverflow/query/new

我正在做：

select max(body) from posts;​

然后返回：

You'd be looking to static link (as opposed to dynamically link)

I'm not sure how many of the MS redistributables statically link in.

Answer 1

max函数返回表达式的最大值。(我认为)您想要的是top和len(body)的组合。

select top 10 len(body), Id as [Post Link] 
from posts
order by len(body) desc

Answer 2

select top 10 body from posts order by len(body) desc;

Answer 3

这样怎么样？

select top 10 len(body) from posts order by len(body) desc​