Subject Re: Reducing the numbers of records returned
Author marcusmonaghan50
> >For exmaple if I had a table called table1 that contained 10,000
> >records and I wrote a query of : select field1, field2 from
> >This obviously will return all of the records, but what I want to
> >is have that query but reduce the result set to say ten records.
> select first 10 field1, field2 from table1.

Brilliant!!! Exactly what I'm after, I don't mind doing a minor
change like that, I can dynamically change the query on the fly.