11 Replies Latest reply: Oct 26, 2012 10:56 AM by Jeff Smith Sqldev Pm-Oracle RSS

    SELECT  * with LIMIT

    969643
      Trying to follow the example :
      SELECT select_list
      FROM table_expression
      [LIMIT { number | ALL }] [OFFSET number]

      SELECT *
      FROM WGN3EVENTAUDIT B,
      WGN3EVENT A
      WHERE A.EVENTUID = B.EVENTUID
      AND A.EVENTTIMESTAMP = B.EVENTTIMESTAMP
      LIMIT 10 | ALL OFFSET 10 ;

      Error at Line: 6 Column: 1

      Not too sure how to correct it