>I am not sure how well supported the LIMIT clause is supported, does Oracle
>support it?

Oracle supports the following syntax for getting only a portion of the
rows which would otherwise be selected with a given where clause...

   select * from Visitor
   where rownum <= 200;

"rownum" is a magic "column" which is incremented for every row that has
been returned.

Stephen



------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to