有两个表,分别为订单表和订单明细表,两表以订单ID进行关系连接,具体分页SQL如下
select * from order_book ,order_msg
where order_book.order_id in
(select top 3 order_msg.order_id from
(select top 3 order_msg.order_id from
order_book )
as temtable )此SQL只能显示全部数据,无法分页,请指点小弟.不胜感谢
select * from order_book ,order_msg
where order_book.order_id in
(select top 3 order_msg.order_id from
(select top 3 order_msg.order_id from
order_book )
as temtable )此SQL只能显示全部数据,无法分页,请指点小弟.不胜感谢
求得的值不正确,请教正确的写法
Pages page = null;
page = new Pages(request, dc, sql);
mainDS = page.getPageData();
request.setAttribute("sumDS", sumDS);
视图应该可以解决