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
Post a Comment