Oh and for those interested, here's all the different ways to limit results:
DB2 -- select * from table fetch first 10 rows only
Informix -- select first 10 * from table
Microsoft SQL Server and Access -- select top 10 * from table
MySQL and PostgreSQL -- select * from table limit 10
Oracle 8i -- select * from (select * from table) where rownum <= 10
Mike Hillyer, Technical Writer
MySQL AB, www.mysql.com
Office: +1 403-380-6535
Blog:
http://www.openwin.org/mike
"The Open Source movement has become a major force across the software industry, and MySQL is the world's most popular open source database."
--Fortune Magazine
Edited 1 time(s). Last edit at 10/28/2004 08:38PM by Mike Hillyer.