户外灯挂钩:如何用sql server语句改写mysql中的limit
来源:百度文库 编辑:高校问答 时间:2024/05/05 19:03:45
sqlStr = "select a.*,b.* from book a,bookclass b"+
" where a.Bookclass = b.Id limit "+
(recordCount-pageSize * page)+","+
(recordCount-pageSize * (page-1));
" where a.Bookclass = b.Id limit "+
(recordCount-pageSize * page)+","+
(recordCount-pageSize * (page-1));