SQL ÐÐÊýµÄÑ¡Ôñ

OracleÊý¾Ý¿â
SELECT
    *
from
(
    SELECT
        ROWNUM AS NO_ROW
        ,row_.*
    from
    (
        SELECT
            *
        from
            PLAN_TEMP
    ) row_
)
WHERE
    NO_ROW BETWEEN 1 AND 12
PostgreSQL
select * from table limit 1 offset 12;
MySQL
select * from table limit 1, 12
SQL Server
select top 12 * from table
·ÖÒ³£º
1.Oracle
SELECT
    *
from (
    SELECT
        row_.*, rownum rownum_
    from
        (...... ) row_
    WHERE
        rownum <= ?)
WHERE rownum_ > ?
ÏÈ°´²éѯÌõ¼þ²éѯ³ö´Ó0 µ½Ò³Î´µÄ¼Ç¼.È»ºóÔÙÈ¡³ö´ÓÒ³¿ªÊ¼µ½Ò³Î´µÄ¼Ç¼.(¾Ý˵ÊÇЧÂÊ×î¸ßµÄ£º£©)  
2. SQL Server
i:select top [pagesize] *
from table
where
    id not in (
        select top [pagesize*(currentpage-1)] id
        from table
        [²éѯÌõ¼þ] order by   id )
    and [²éѯÌõ¼þ] order by id
ÏÈ°´²éѯÌõ¼þÅųý pagesize*[pagesize* (currentpage-1)]ÒÔÇ°µÄ¼Í¼¡£&&ÔÙ°´²éѯÌõ¼þ°ÑËûÒÔºóµÄ¼Ç¼ top[pagesize] ³ö À´.
ii: select top PageSize *
from TableName
where id > (
    select max(id)  
    from
        (select top startRecord-1 id
        from TableName
        [²éѯÌõ¼þ]