SQLServer方言调用searchFirst出现异常

[zxlaole]

SearchFirst等调用时，运行时产生异常offset”附近有语法错误，SQL语句查询条件为where (t.id = ?) and (t.invcust = ?) offset ? rows fetch next ? rows only。数据库版本Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 。

[zxlaole]

查过资料，SQLServer的offset要写成 ORDER BY (SELECT NULL) -- 必须有 ORDER BY
OFFSET 1 ROWS
FETCH NEXT 1 ROWS ONLY;