Oracle, DB2 ¼° MySQL ·ÖÒ³²éѯд·¨

 
ÏÖÔÚÔÚWEB Ó¦ÓÃÖÐʹÓ÷ÖÒ³¼¼ÊõÔ½À´Ô½ÆÕ±éÁË£¬ÆäÖÐÀûÓÃÊý¾Ý¿â²éѯ·ÖÒ³ÊÇÒ»ÖÖЧÂʱȽϸߵķ½·¨£¬
ÏÂÃæÁгöÁËOracle, DB2  ¼° MySQL ·ÖÒ³²éѯд·¨¡£
Ò»£ºOracle
select * from (select rownum,name from table where rownum <=endIndex )
where rownum > startIndex
¶þ£ºDB2
DB2·ÖÒ³²éѯ
SELECT * from (Select ×Ö¶Î1,×Ö¶Î2,×Ö¶Î3,rownumber() over(ORDER BY ÅÅÐòÓõÄÁÐÃû ASC) AS rn from ±íÃû) AS a1 WHERE a1.rn BETWEEN 10 AND 20
ÒÔÉϱíʾÌáÈ¡µÚ10µ½20µÄ¼Í¼
select * from (select rownumber() over(order by id asc ) as rowid from table where rowid <=endIndex ) AS a1
where a1.rowid > startIndex
Èý£ºMySQL
select   *   from   table   limit   start,pageNum  
SELECT EVENTID  , EVENTNAME  , CREATETIME  , ELAPSEDTIME  , REPEATCOUNT  , MESSAGE  , LOCALINSTANCEID , STATUS , MEMO from(SELECT rownumber() OVER (ORDER BY CREATETIME ASC) AS rowid from MS_EVENT WHERE rowid <=20) as a1 WHERE a1.rowid >10
SELECT * from (SELECT EVENTID  , EVENTNAME  , CREATETIME  , ELAPSEDTIME  , REPEATCOUNT  , MESSAGE  , LOCALINSTANCEID , STATUS , MEMO,
ROWNUMBER() OVER (ORDER BY CREATETIME  ASC) AS rn from MS_EVENT) AS a1 WHERE a1.rn BETWEEN 10 and 20
--------------------------------------------------------------------
1. ±ê×¼µÄrownum·ÖÒ³²éѯʹÓ÷½·¨£º
    select *
      from (select c.*, rownum rn from content c)
     where rn >= 1
       and rn <= 5
    2. µ«ÊÇÈç¹û, ¼ÓÉÏorder by addtime ÅÅÐòÔòÊý¾ÝÏÔʾ²»ÕýÈ·
    select *
      from (select c.*, rownum rn from content c order by addtime)
     where rn >= 1
       and rn <= 5
    ½â¾ö·½·¨£¬ÔÙ¼ÓÒ»²ã²éѯ£¬Ôò¿ÉÒÔ½â¾ö£¬
    select *
      from (s