From: Martijn Tonies
Date: April 27 2010 10:45am
Subject: Re: How to select rows from only the first N rows in a table?
List-Archive: http://lists.mysql.com/mysql/221415
Message-Id: <013501cae5f6$ce5df4e0$6101a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit



> 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