Re: LIMIT first offset 0 or 1 ? and other LIMIT problems

["Gerald L. Clark" <gerald_clark@xxxxxxxxxxxxxxxxxxx>]

Angel Behar Rodriguez wrote:
> 
> Hi, !!! thanks for your answer, here is the test you ask for.
> 
> mysql> SELECT count(*) from ropa where cve_depto='3' AND cve_clase ='03'
>     -> AND
>     -> cve_familia='001';
> +----------+
> | count(*) |
> +----------+
> |      398 |
> +----------+
> 1 row in set (0.07 sec)
> 
> In fact now it's working but I take out the GROUP BY from the query.
> 
> But the offset 0 or 1 still not working.
> 
LIMIT Y   means return the first Y rows.
LIMIT X,Y means skip the first X rows and return the next Y rows.
It is working correctly as you show.

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60404@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php