> I just thought I would add another thing here for you before it comes up.
> 
> There is no native LIMIT (MySQL) clause in Oracle.  However you can
> mimic the behaviour of the LIMIT with a nested query.  The simplest
> way to do this is if your Oracle install has OLAP functionality. 
> [...]
> If your database does not have OLAP, then it will take a triple-nested
> SELECT that would look something like:
> Hope you find this useful.

Well Keith, that's impressive. Can you also post some benchmarks? ;)


Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-list/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 



Reply via email to