开发者

ROW_NUMBER() in linqpad

开发者_StackOverflow中文版

I am trying to get row numbers to show up in my LINQPad query.

SELECT ROW_NUMBER() OVER(ORDER BY TestNum) AS 'Row Number', TestNum
FROM Test

I get:

Error 195: 'ROW_NUMBER' is not a recognized function name.

I also tried

ROWNUM()

{ fn ROW_NUMBER() }

{ fn ROWNUM() }

among others...

I am using LINQPad v4.20

Thanks.


What version of SQL Server are you using? ROW_NUMBER() is not available in SQL Server 2000 or earlier.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜