In Vfp you use "select top 10 * from xtab", same MS Sql Server, and you have ten first records from table, in Oracle you must use rownum: "select * from xtab where rownum<=10" and for information in db2 "select * from xtab fetch first 10 rows only"