incubator-empire-db-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francis De Brabandere <franci...@gmail.com>
Subject Re: LIMIT implemented since 2.0.7 but what about SKIP ?
Date Mon, 28 Mar 2011 14:57:07 GMT
The function skipRows() is available for MySQL

more info here:
https://issues.apache.org/jira/browse/EMPIREDB-62

Cheers,
Francis

On Mon, Mar 28, 2011 at 4:40 PM, exxos <hatufr@gmail.com> wrote:
> Hi,
>
> I noticed that since the version 2.0.7, you added the feature "limit" to
> allow controling the number of row that a query can return.
> But, now I would like to know about the feature "skip" to skip a number of
> row? This is a feature offered mainly by MySQL but really usefull and
> popular and probably common to all others Database engines.
>
> For example, to skip the 10 first rows but keep the limit to 100.
>
> SELECT * FROM table LIMIT 10,100
>
> Could you please advise ?
>
> Regards,
> exxos.
>



-- 
http://www.somatik.be
Microsoft gives you windows, Linux gives you the whole house.

Mime
View raw message