Select entries skipping rows in MS Access

Question

How to select some records in the database, skipping the number of rows in MS Access. In MySQL LIMIT x, y. Firebird - FIRST x SKIP yetc.

Google is out of luck = (

+5

Dontvotemedeown May 04 '12 at 20:31

1 answer

Taryn · Accepted Answer · 2012-05-04T20:49:50+0000

If you know how many records you want to skip, you can do something like this:

SELECT *
FROM myTable x
WHERE x.ID NOT IN (SELECT Top 10 id FROM myTable ORDER BY ....)
ORDER BY ...

You can then exclude entries that you do not want.

If you know the total number of records you want to return, you can do the following:

SELECT Top 50 *
FROM myTable x
WHERE x.ID NOT IN (SELECT Top 10 id FROM myTable ORDER BY ....)
ORDER BY ...