下面是我想实现分页的sql语句,其中pageSize是每页显示的记录数,而curPage 则是当前的页数,想通过下面的Sql语句查询出当前页的记录数。但是在测试的时候总是提示“关键字 'from' 附近有语法错误”,大家帮我看一下吧。当然了 如果大家有什么更好的实现这种功能的办法,也非常欢迎大家建议啊!String sql="select top"+pageSize+ " * from topic where column_id not in(select top "
+pageSize*(curPage - 1)+ " column_id from topic order by column_id) order by column_id ";
+pageSize*(curPage - 1)+ " column_id from topic order by column_id) order by column_id ";
String sql="select top "+pageSize+ " * from topic where column_id not in(select top "
+pageSize*(curPage - 1)+ " column_id from topic order by column_id) order by column_id ";