Retrieve record from Access DB

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
desmondlk
Forum Commoner
Posts: 27
Joined: Tue Sep 24, 2002 10:27 pm
Location: Malaysia

Retrieve record from Access DB

Post by desmondlk »

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.
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post by JAM »

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.
Post Reply