Oracle、MySQL和SqlServe三种数据库分页查询语句的区

String sql = "select  "+pageRecord +"  from addressbook where id not in (select  "+(currentPage-)pageRecord +" id from t_user)"; 
// (currentPage-)pageRecord : 是指从第几个记录开始 

select  20  from addressbook where id not in (select  10 id from addressbook)

String sql = "select  from addressbook where limit "+(currentPage-)pageRecord +","+pageRecord +""; 
//select  from 表名 【条件】limit M,N; 
//M为从第几个记录开始，比如每页显示条记录，第二页就必须从第条记录开始 
//N每页读几个数据 

select  from addressbook where limit 10,10

String sqls = "select  from ( select rownum rn,t. from addressbook t where rownum <= "+currentPagepageRecord+" ) where rownum > "+(currentPage -1)pageRecord; 

select  from ( select rownum rn,t. from addressbook where rownum<= 20 ) where rownum > 10