sqlserver通用分页sql语句
解决方法:
String SQLSERVER_SQL = "select * from ( select row_number() over(order by tempColumn) tempRowNumber, * from
(select top {1} tempColumn = 0, {0}) t ) tt where tempRowNumber > {2}";
sqlserver通用分页sql语句
解决方法:
String SQLSERVER_SQL = "select * from ( select row_number() over(order by tempColumn) tempRowNumber, * from
(select top {1} tempColumn = 0, {0}) t ) tt where tempRowNumber > {2}";