sql语句报错:ORA-00907: 缺失右括号

2025-01-08 01:55:18
推荐回答(2个)
回答1:

SELECT * FROM
(SELECT ROW_NUMBER() OVER(ORDER BY USER_ID)AS RowNumber FROM TEST WHERE RowNumber BETWEEN Limit(N-1)+1 AND Limit*N) a;

回答2:

Limit*N是什么鬼啊,这个压根不能计算