Sean,
Thursday, October 10, 2002, 10:54:24 PM, you wrote:
SM> In a previous job I had the (mis)fortune to develop software exclusively on
SM> DB2. While doing so I would often use FETCH to examine a certain number of
SM> records. Example:
SM> SELECT * from table FETCH FIRST 10 ROWS ONLY.
SM>
* Sean Moshenko
[...]
> SELECT * from table FETCH FIRST 10 ROWS ONLY.
Check out the LIMIT option of the select statement:
http://www.mysql.com/doc/en/SELECT.html >
SELECT * from table LIMIT 10
--
Roger
-
Before posting, ple
Hi,
In a previous job I had the (mis)fortune to develop software exclusively on
DB2. While doing so I would often use FETCH to examine a certain number of
records. Example:
SELECT * from table FETCH FIRST 10 ROWS ONLY.
When I use this particular syntax in any mysql interface (I've used 2) I g
