Hi All,
May I know how to retrieve record from Access database by limiting the number of records being return?
For example, if the table has 30 records and I decided to retrieve 20 records starting from the first. How can do this in Access by using SQL statement?
Thanks in advance.
Desmond.
Retrieve record from Access DB
Moderator: General Moderators
http://www.phpfreaks.com/tutorials/61/0.php
"select top 20 * from table" i guess would be a good start dealing with the select-clause retrieving 20 of 30 rows.
"select top 20 * from table" i guess would be a good start dealing with the select-clause retrieving 20 of 30 rows.