> It seems that there is no direct support to limit 'select' to only the
> first N rows in a table. Could you let me know what the best way
> select rows from the first N rows in a table is?
LIMIT usually works fine ;-)
http://dev.mysql.com/doc/refman/5.0/en/select.html
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
