All,
Is it possible, and if so how, to reduce the number of record
returned by a query without changing the query?

For exmaple if I had a table called table1 that contained 10,000
records and I wrote a query of : select field1, field2 from table1.
This obviously will return all of the records, but what I want to do
is have that query but reduce the result set to say ten records. I
want to do this because I'm writting a front end screen that will
allow my clients to query the database and I want to have a feature
of letting them view sample data from the query that they write.

Regards,
Marcus.