Search code examples
limitdbase

How to do a limited query like MySQL (LIMIT 0, 10) on Dbase?

It is possible?

I know you can limit your queries with 

 SELECT TOP 10 name FROM customers ORDER BY name

but how can I get names from 50 to 100?

I need to make a pagination but I can't find a way to do it.

Thank you very much.

Solution

  • There is more simple way:

    SELECT * FROM table1 WHERE RECNO()>50 AND RECNO()<=100