JFIF$        dd7 

Viewing File: /usr/share/doc/firebird/sql.extensions/README.offset_fetch.txt

-----------------------
OFFSET and FETCH clause
-----------------------

  Function:
    SQL:2008 compliant equivalent for FIRST/SKIP, and an alternative for ROWS.
    The OFFSET clause specifies the number of rows to skip. The FETCH clause 
    specifies the number of rows to fetch.
    
    OFFSET and FETCH can be applied independently on top-level and nested query
    expressions.
    
  Author:
    Mark Rotteveel <mrotteveel@users.sourceforge.net>
    
  Syntax rules:
    SELECT ... [ ORDER BY <expr_list> ] 
      [ OFFSET <simple_value_expr> { ROW | ROWS } ]
      [ FETCH { FIRST | NEXT } [ <simple_value_expr> ] { ROW | ROWS } ONLY ]
    
    Where <simple_value_expr> is a (numeric) literal, a SQL parameter (?) or 
    PSQL named parameter (:namedparameter).
  
  Scope:
    DSQL, PSQL
  
  Example(s):
    1. SELECT * FROM T1
       ORDER BY COL1
       OFFSET 10 ROWS
    2. SELECT * FROM T1
       ORDER BY COL1
       FETCH FIRST 10 ROWS ONLY
    3. SELECT * FROM (
          SELECT * FROM T1
          ORDER BY COL1 DESC
          OFFSET 1 ROW
          FETCH NEXT 10 ROWS ONLY
       ) a
       ORDER BY a.COL1
       FETCH FIRST ROW ONLY
  
  Note(s):
    1. Firebird doesn't support the percentage FETCH defined in the SQL 
       standard.
    2. Firebird doesn't support the FETCH ... WITH TIES defined in the SQL
       standard.
    3. The FIRST/SKIP and ROWS clause are non-standard alternatives.
    4. The OFFSET and/or FETCH clauses cannot be combined with ROWS or 
       FIRST/SKIP on the same query expression.
    5. Expressions, column references, etc are not allowed within either clause.
    6. Contrary to the ROWS clause, OFFSET and FETCH are only available on 
       SELECT statements.
Back to Directory  nL+D550H?Mx ,D"v]qv;6*Zqn)ZP0!1 A "#a$2Qr D8 a Ri[f\mIykIw0cuFcRı?lO7к_f˓[C$殷WF<_W ԣsKcëIzyQy/_LKℂ;C",pFA:/]=H  ~,ls/9ć:[=/#f;)x{ٛEQ )~ =𘙲r*2~ a _V=' kumFD}KYYC)({ *g&f`툪ry`=^cJ.I](*`wq1dđ#̩͑0;H]u搂@:~וKL Nsh}OIR*8:2 !lDJVo(3=M(zȰ+i*NAr6KnSl)!JJӁ* %݉?|D}d5:eP0R;{$X'xF@.ÊB {,WJuQɲRI;9QE琯62fT.DUJ;*cP A\ILNj!J۱+O\͔]ޒS߼Jȧc%ANolՎprULZԛerE2=XDXgVQeӓk yP7U*omQIs,K`)6\G3t?pgjrmۛجwluGtfh9uyP0D;Uڽ"OXlif$)&|ML0Zrm1[HXPlPR0'G=i2N+0e2]]9VTPO׮7h(F*癈'=QVZDF,d߬~TX G[`le69CR(!S2!P <0x<!1AQ "Raq02Br#SCTb ?Ζ"]mH5WR7k.ۛ!}Q~+yԏz|@T20S~Kek *zFf^2X*(@8r?CIuI|֓>^ExLgNUY+{.RѪ τV׸YTD I62'8Y27'\TP.6d&˦@Vqi|8-OΕ]ʔ U=TL8=;6c| !qfF3aů&~$l}'NWUs$Uk^SV:U# 6w++s&r+nڐ{@29 gL u"TÙM=6(^"7r}=6YݾlCuhquympǦ GjhsǜNlɻ}o7#S6aw4!OSrD57%|?x>L |/nD6?/8w#[)L7+6〼T ATg!%5MmZ/c-{1_Je"|^$'O&ޱմTrb$w)R$& N1EtdU3Uȉ1pM"N*(DNyd96.(jQ)X 5cQɎMyW?Q*!R>6=7)Xj5`J]e8%t!+'!1Q5 !1 AQaqё#2"0BRb?Gt^## .llQT $v,,m㵜5ubV =sY+@d{N! dnO<.-B;_wJt6;QJd.Qc%p{ 1,sNDdFHI0ГoXшe黅XۢF:)[FGXƹ/w_cMeD,ʡcc.WDtA$j@:) -# u c1<@ۗ9F)KJ-hpP]_x[qBlbpʖw q"LFGdƶ*s+ډ_Zc"?%t[IP 6J]#=ɺVvvCGsGh1 >)6|ey?Lӣm,4GWUi`]uJVoVDG< SB6ϏQ@ TiUlyOU0kfV~~}SZ@*WUUi##; s/[=!7}"WN]'(L! ~y5g9T̅JkbM' +s:S +B)v@Mj e Cf jE 0Y\QnzG1д~Wo{T9?`Rmyhsy3!HAD]mc1~2LSu7xT;j$`}4->L#vzŏILS ֭T{rjGKC;bpU=-`BsK.SFw4Mq]ZdHS0)tLg