LIMIT

[Anon]

Hi.

Does anyone know if it is possible to use LIMIT with an access database?
I've tried "SELECT * FROM table LIMIT 5,10" but obviously it's not the right way to do it.
Could anyone give me an example? (I'm using access2002)

Thanks!

[[deleted]]

have you tried pressing 'F1' in MS-Access? :-)

www.microsoft.com is bound to hold that answer too.

[Anon]

I've tried, but I can't find anything about it...

[smarlowe]

Try SQL 92 syntax, like:

select * from table1 limit1 offset 5

and see if that works...

[Anon]

Access has the top keyword. If you wish to have an offset you have to write like this.

select top 5 * from t where c not in (select top 5 c from t order by c) order by c

[Anon]

Limit is not ANSI sql.