>I have command "SELECT * FROM table WHERE ORDER BY ", which returns e.g. 100 records, but I want use first or last 10 records only. How to correct this command for this purpose? >I donn't want to use "TOP 10" clause, because it can return more than 10 records. I want exactly 10 records (if exist, of course).
Just use a little xbase then.
SELECT * FROMtableINTOCURSOR temp WHERE conditions ORDERBYcolumnCOPYNEXT 10 TO filename