I am attempting to pull ALOT of data from a fox pro database, work with it and insert it into a mysql db. It is too much to do all at once so want to do it in batches of say 10 000 records. What is the equivalent to LIMIT 5, 10 in Fox Pro SQL, would like a select statement like

select name, address from people limit 5, 10;

ie only get 10 results back, starting at the 5th. Have looked around online and they only make mention of top which is obviously not of much use.

View More Answer And Comment : Stackoverflow

## Top Answer 1

Visual FoxPro does not support LIMIT directly.

I used the following query to get over the limitation:

SELECT TOP 100 * from PEOPLE WHERE RECNO() > 1000 ORDER BY ID;

where 100 is the limit and 1000 is the offset.

## Top Answer 2

Visual FoxPro does not support LIMIT directly.

I used the following query to get over the limitation:

SELECT TOP 100 * from PEOPLE WHERE RECNO() > 1000 ORDER BY ID;

where 100 is the limit and 1000 is the offset.

## Top Answer 3

Visual FoxPro does not support LIMIT directly.

I used the following query to get over the limitation:

SELECT TOP 100 * from PEOPLE WHERE RECNO() > 1000 ORDER BY ID;

where 100 is the limit and 1000 is the offset.

## Top Answer 4

I used the following query to get over the limitation:

SELECT TOP 100 * from PEOPLE WHERE RECNO() > 1000 ORDER BY ID;

where 100 is the limit and 1000 is the offset.

## Top Answer 5

I used the following query to get over the limitation:

SELECT TOP 100 * from PEOPLE WHERE RECNO() > 1000 ORDER BY ID;

where 100 is the limit and 1000 is the offset.

## Top Answer 6

I used the following query to get over the limitation:

SELECT TOP 100 * from PEOPLE WHERE RECNO() > 1000 ORDER BY ID;

where 100 is the limit and 1000 is the offset.

View More Answer And Comment : Stackoverflow