Bill,
Try to find a copy of 'SQL for Smarties' by Joe Celko.
Chapter 25 Subsets has example code for the Top N values which I have
successfully used in the past to get Next N as well.
The final iteration of the code to display top three salaries (taken
from the book) is :-
select distinct
...
Thanks...
-Original Message-
From: Mark Thornber [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 12:34 AM
Subject: Re: Limiting the number of records selected.
Try to find a copy of 'SQL for Smarties' by Joe Celko.
Chapter 25 Subsets has example code for the Top N values wh
Continuing the ongoing saga... I wrote that the "top-n" queries in
Oracle can be handled by using a nested SELECT with an ORDER BY, then
using ROWNUM in the external WHERE clause. But...
I just tried it on our instance and it doesn't work. We are on
Oracle7 Server Release 7.3.4.5.0. Is
Bill,
I'm sure somebody else will have something more specific than this for your
needs, but let me give it a shot with the Syntax of the DBMS I use all the
time (Which, also does not have a limit keyword). Do you have a TOP keyword?
If so, you can probably do something like:
SELECT TOP 10
"Bill" == Bill OConnor [EMAIL PROTECTED] writes:
Bill I want to use a subset of the selected rows on a webpage. For
Bill instance if the query returns 100 rows I want show just 10 of
Bill them on the page, 11-20 on the next etc.
Look at the discussion of the ROWNUM pseudo-column, in the