This discussion is archived
11 Replies Latest reply: Oct 26, 2012 8:56 AM by Jeff Smith SQLDev PM RSS

SELECT  * with LIMIT

969643 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points