Selecting Middle Entries

[fpgiv]

Hi,
I know that with sql, you can return the top 10, 20 or whatever number of values you need from a table. Is there a way to bring back the middle entries from a query. For example, instead of bringing back the first 20 entries of a query, I would like to bring back the 11th through 20th entries.
Is this doable?
Thanks!
~Phil

 

[donutman]

BTW, mwolf00's method seems to be equally fast unless I select all columns in which case it's 60% slower. Don't understand that.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[donutman]

A bit of serendipity, does it count if it's the result of not being too smart? The code with the @First and @Last runs twice as fast as the code with @First and top 10,000. Who would know?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[ESquared]

Weird! Are you measuring this by SQL Profiler or by just plain time to run?

I think there's a cost with ordering that I never considered before.

About the fuzziness, I thought of that too when working on the problem myself... but filed it away for future thought because the problem was specific numbers, not groups touching the boundaries.

 

[donutman]

Ahh...Profiler...ahh what's that? Isn't time to run good enough?
On the specific numbers: it seems like it's only an academic question, the more likely real world problem is to bring back disconnected recordsets of batches of reasonable size from the server.
So what do your Profiler tests show?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[ESquared]

I didn't finish testing... had to do some real work.

 

[donutman]

Have a Happy New Year Esquared, tell your boss that you are taking the rest of the year off to get some rest.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[donutman]

So where's the performance tests? Have I found the Holy Grail? The solution that not only is NOT a single query, but is easier to understand and faster to boot!
Am I finally vindicated for my ^BOXING!
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[ESquared]

I'm busy with important stuff!!!

Seriously, I have a ton of work right now, am busy in the evenings with my fiancée and houseguests and wedding plans and all sorts of things.