Description of the illustration hier_lead_lag_clause.eps

member_expression  OFFSET offset_expr
  [ WITHIN 
    {  { LEVEL | PARENT }
    | ACROSS ANCESTOR AT LEVEL level_ref [ POSITION FROM { BEGINNING | END } ]
    }
  ]