General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Thanks for your reply John
>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"
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only