RE: [PHP] LIMIT clause in ORACLE???

Errr sorry <embarrassed> !! :) Read the MySQL and Oracle bit around the wrong way.....I'll go back to sleep and blame it on a Friday.... From: "Jerry Hutchings" <jeremy.hutchings@i-dmedia.com > In the manual...........that's what its for........ > > [LIMIT [offset,] rows] > > http://www.mysql.com/Manual_chapter/manual.php?section=SELECT Hmmm - using a MySQL manual to look up answers to an Oracle question. Guess he'll be up all night :^) Take a look in Oracle manuals about ROWNUM, as in select * from table1 where ROWNUM < 10 and if it's a large table then select /*+ FIRST_ROWS */ * from table1 where ROWNUM < 10 may work significantly faster. Mark Charette@sneezy.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net