Re: Limiting the result set

On Fri, Aug 16, 2002 at 10:06:23 +0200,
  Rob <rob@jamwarehouse.com> wrote:
>
> Is there any way, IN ONE QUERY, to do this.  So I want to basically return
> the first 500 results
> and a count of the total result set in one go.  Is this possible?
>
> If not, what would be the quickest way to do this?  The reason I need one
> query is because I use
> dynamic SQL, which complicates stuff a bit more

It is certainly possible to do this, if not efficient.

You can always just union two queries together using an extra column that
is null for the real records and returns the full count in a special
record. Order by can be used to make this record first or last.