MYSQL 的分页语句怎样转换成SQLserver的？

Question

    public ArrayList<Score> getOnePage(int page,int size) throws Exception{
        ArrayList<Score> al = new ArrayList<>();
        initConnection();
        String sql = "SELECT * FROM score limit ?,? ";
        PreparedStatement ps = conn.prepareStatement(sql);
        ps.setInt(1, (page-1)*size);
        ps.setInt(2, size);
        ResultSet rs =  ps.executeQuery();
        getMoreScore(al, rs);
        closeConnection();
        return al;
    }

Answer 1

MSSQL使用row_number开窗函数分页
;with t as (select *,row_number() over (order by id) as RN from score)
select * from t where RN between ? and ?