第四十号交响曲简谱:如何用sql server语句改写mysql中的limit
来源:百度文库 编辑:高考问答 时间:2024/05/12 20:33:20
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));