How to select only 500 records and next 500 ?

How to select only 500 records and next 500 ?

Post by Want To Kno » Fri, 27 Aug 1999 04:00:00


I have a very huge database here. More than 200 thousand records.
How do I limit the SQL statement only retrieve the Top 500 records that
match the criteria ?
I'm using a LIKE statement, that's is the request from the user. Retrieve
records base only LIKE matching.

Question is, how do I retrieve the first 500 matches and then subsequent 500



1. DBMS selection for 500+GB and 500+users

We are in the process of selecting a database for our data warehouse.  It is
expected to start at 50GB of data with 50+ users and grow over the next 2
years to be 500+GB of data and 500+ users. Much of the data will be obtained
from our IBM mainframe  ADABAS operational databases on a daily basis.   We
are looking at Sybase, Informix and Oracle.  Does anyone have experiences
(good or bad) that might help with our decision.  In particular, how do
these products scale throught this type of growth.  Thanks

2. Process for data transfer from SQL6.5 - 7.0

3. DBMS Selection for 500+GB data and 500+ Users

4. Paradox 9 on Win2k Workstation with Novell Server

5. How do i randomly select 500 rows from a table

6. WANTED: Fox Pro contractor rates

7. BLOBS (was: 500'000 records)

8. DBCombo help

9. SQL Server and 500 000 000 records ?

10. Attached Excel sheet in Access stops after every 500 records

11. Returning first 500 records

12. 500'000 records - who does best?

13. fetch records 500-1000 at a time