sql - How to implement pagewise loading in MSAccess -


in application using msaccess db, need implement pagewise loading sql query.

i know how load first 10 records, thats by

select top 10 * product order dateadded desc 

but how can pick record 10 20.

any idea?

it's possible in access sql, not straightforward in other database products.
(for example mysql, limit 10,10)

check out answer here:
how ms access database paging + search?

(the code build sql statement in c#, of course can in other language well. if don't know c# , need understanding answer, leave comment here)


Comments

Popular posts from this blog

html5 - What is breaking my page when printing? -

html - Unable to style the color of bullets in a list -

c# - must be a non-abstract type with a public parameterless constructor in redis -