mssql server 2008的分页查询在"OFFSET"附近抛出错误的语法 [英] Pagination query for mssql server 2008 Throwing Incorrect syntax near 'OFFSET'

问题描述

我正在使用jsp进行分页(并且我是初次接触sql).

I am Working on pagination in jsp(and i am new to writing sql).

我完成了研究，发现了来自

I done my research and found simple queries from

在SQL Server 2008中进行分页和

在上面的查询中，ipageNo首次为0(即使我尝试手动输入1)

in the above query ipageNo is coming 0 for the first time(even i tried by putting 1 manually)

仍然显示错误Incorrect syntax near 'OFFSET'.

我在这里错过了什么?预先感谢.

What i missed here ? Thanks in advance.

推荐答案

这是我的工作，现在工作正常.

Here is my work around and working fine now.

SELECT * FROM   (SELECT ROW_NUMBER() OVER(ORDER BY id) AS rownumber,*
        FROM document)  as somex  WHERE  rownumber >= (1+1)*10-9
                         AND rownumber <=(1+1)*10

在上述查询中，我将(1+1)替换为(pageNUmber+1).

In the above query i am replacing (1+1) with (pageNUmber+1).

如果有任何优雅的方法，请随时建议我.

Please feel free to suggest me if any elegant way available.

这篇关于mssql server 2008的分页查询在"OFFSET"附近抛出错误的语法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！